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 Export to MS Excel

Author  Topic 

scootermcfly
Yak Posting Veteran

66 Posts

Posted - 2001-10-02 : 14:45:40
I am using a DTS package to export data from SQL to a Excel Spreadsheet two to three times a month and the column names for this change monthly. This first time that it is executed each month, I need to change the package and populate from source for column names in sql otherwise it errors out.

Is there an option that I am missing to set this to populate from source each month?

Thanks,
Scooter McFly
   

- Advertisement -