sql server dts: creating an excel worksheet -- sql server dts

creating an excel worksheet

chris
3/26/2004 8:57:11 AM

sql server dts:

I think Im close to being able to create an excel
worksheet in dts. Can someone please lend a hand??? Ive
searched online and cant really find this same task
anywhere.

Function Main()

Dim exl, MyFile
Set exl = CreateObject("Excel.Application")
Set MyFile = exl.CreateTextFile("c:\test.xls",
True)
Main = DTSTaskExecResult_Success
End Function

Re: creating an excel worksheet

Allan Mitchell
3/26/2004 5:18:24 PM

If I remember correctly this will not produce an XL readable XL Spreadsheet.

You will need to use the Object model to create a brand new one.

--

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]