Re: create excel work*** from Active X Script Task Props

From: Allan Mitchell (allan_at_no-spam.sqldts.com)
Date: 03/26/04 

Date: Fri, 26 Mar 2004 06:33:54 -0000

personally I would be using the Excel object model to do this

There are plenty of examples "Googling" for this 

-- 
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"chris" <anonymous@discussions.microsoft.com> wrote in message
news:13e3d01c412c8$9b631e60$a101280a@phx.gbl...
> sql2k sp3
>
> In Active X Script Task Props, I can use the
> FileSystemObject to create a file.
>
>
> Function Main()
> Dim fso, MyFile
> Set fso = CreateObject
> ("Scripting.FileSystemObject")
> Set MyFile = fso.CreateTextFile("\\packrat\Dept-
> IT\chris\excel\DailyRefundFromSQL\sqlout.xls", True)
> Main = DTSTaskExecResult_Success
> End Function
>
>
> Is there something that can replace the FSO to create an
> Excel file in a readable format?
>
> Sample code would be ideal?
>
> TIA, Chris