I have a table for users in a SQL Database. Everyday people sign up and put in a new row of information. I want to be able to export the new rows every night as a new CSV file on an FTP location, I would also like to update the table with a flag so I do not query the information twice. Is this possible with a DTS package, can someone give me some insight or an example of how this is done.
Appreciate the help,