Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 DTS to Excel

Author  Topic 

net4hire
Starting Member

6 Posts

Posted - 2004-11-19 : 17:58:15
I have a DTS package that exports records to an excel file daily. For each day that records are exported, a new worksheet should be created with the current date. But Excel always names the worksheet the same name as the table name being used to create the table in a Execute SQL Task of the DTS file.

Thanks in advance...
   

- Advertisement -