Iam trying to export data from sql server to excel for back up because they want it in a excel spread sheet..Now its a 10 days backup.
Query and everything is fine...the only problem is I want to run the dts everyday and it should export to different excel files in the same folder.When i first runs its okay.. now when I again want to do the same process the next day..I have to recreate another excel file and all the tables and mapping for the seond excel..i want a script which can automatically create different files each time when I run the dts.the query and mapping is same for all these 10 days..can we do something with data driven query task and execute sql task...
Please do help me..
Query and everything is fine...the only problem is I want to run the dts everyday and it should export to different excel files in the same folder.When i first runs its okay.. now when I again want to do the same process the next day..I have to recreate another excel file and all the tables and mapping for the seond excel..i want a script which can automatically create different files each time when I run the dts.the query and mapping is same for all these 10 days..can we do something with data driven query task and execute sql task...
Please do help me..