Creating different Export files from DTS package 1

[MtProgrammer]

Does anyone know how to create multiple .csv files from a table containing the list of names? I have a DTS package that imports a flat file containing accounts and their email addresses, and would like to then export each of these rows into their own .csv file for emailing out. I'm not sure how to set up a looping routine that will create a new file name & store the related data correctly. Any comments or ideas would be helpful.

 

[yksvaan]

Have a look at (SQL2000) Write File Transformation, with some effort I think you can achieve what you need. I remember WFT is appending write, so you somehow have to delete existing files before Transformation, in the case you want just new data.

Cheers


[blue]Backup system is as good as the latest recovery[/blue]