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)
 Query results to New Excel File in DTS

Author  Topic 

EASYSQL
Starting Member

10 Posts

Posted - 2006-04-04 : 10:39:59
I have to design a DTS package where the results of the query need to be dumped in a new excel file or it can be a csv file.But everytime the package is run it should have the results dumped in a new file.
How can i achive this. I am able to dump it into same file again and again but it should be a new file everytime.
Thanks in advance.

Srinika
Master Smack Fu Yak Hacker

1378 Posts

Posted - 2006-04-04 : 10:54:35
U can use the following

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926
(u may need to have a variable as the file name and change it in a way u want it. eg. with the date as file name)

Srinika
Go to Top of Page
   

- Advertisement -