I need to send a csv file to a company from data gathered using various stored procedures on our db. There will be a monthly full export of all records and a weekly export of new/updated records.
What is the best way to go about this? Should i write a web service with two methods and set up two windows scheduled task to run the web service? Is it better to get MS SQLServer to export the data as a csv file or get .net to build the csv itself?
Any help/guidance/ideas greatly appreciated.