create excel worksheet from Active X Script Task Props -- sql server dts

chris
3/25/2004 4:23:48 PM

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?

Allan Mitchell
3/26/2004 6:33:54 AM

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

[quoted text, click to view]

sql server dts : create excel worksheet from Active X Script Task Props