Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Gopher
Yak Posting Veteran
83 Posts |
 Posted - 2006-06-12 : 07:48:40
|
| Hi AgainYou may have seen my other post about transfering data and this is sort of similar.I have created a DTS package which exports data using a stored procedure and then imports it into an Excel File. I have to create 20 files and the only data that changes is 1 value for the stored procedure and the name of the excel file.Does anyone know how to do this programmatically? So that I don't have to run 20 jobs to get the 20 files - I could just run one which will do it for me?Cheers |
|
|
|
|
|
Export Data / DTS