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  SQL Server Development (2000)  Exporting to dated file names

Author  Topic  dith Starting Member 24 Posts Posted - 2001-08-15 : 21:06:29 Hi! I'm creating a table which i need to export as an excel or txt file with the date on the file name, for example: 20010815_upload_file.xls or 20010815_upload_file.txt. i can create the table in sql with 20010815_upload_file as the table name. How do i make my dts package to create the excel file(20010815_upload_file.xls) from this table(20010815_upload_file) considering a new table gets created and needs to be exported everyday?