Help with Excel file in DTS

[bburnell]

Hi all,

I'm using Excel XP with SQL Server 2000. I have a DTS that creates an Excel file via data from the SQL Server. In the past we have used the "Close Connection" checkbox at the end of the step, but this will also close the SQL connection and drop the temp table(s) we need to complete the package. Is there a way to just close the excel file without closing the SQL connection as well?

Thanks!!
Brett

--------------------------
Web/.net Programmer & DBA
Central PA

 

[bburnell]

Nevermind. This works perfectly...

http://support.jodohost.com/showthread.php?t=1192

--------------------------
Web/.net Programmer & DBA
Central PA