Exporting data in a monthly manner by DTS

[MikePort]

I am looking for a script whichs exports data (by DTS?) into a flat file and store the files (according their date stamp in the transactions) with a name like 05_2002.txt, 06_2002.txt etc. The data in the table Transactions will be deleted after some time to prevent fast growing of this particular table.

Any idea?

Thanks

Mike

[MAK]

The best link u can look at it is
http://www.sqldts.com




------------
MikePort at 5/27/2002 3:43:20 PM

I am looking for a script whichs exports data (by DTS?) into a flat file and store the files (according their date stamp in the transactions) with a name like 05_2002.txt, 06_2002.txt etc. The data in the table Transactions will be deleted after some time to prevent fast growing of this particular table.

Any idea?

Thanks

Mike