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 |
|
WJHamel
Aged Yak Warrior
651 Posts |
 Posted - 2012-03-29 : 17:01:51
|
| i have about 30 SSIS packages that import data from different excel files. Is there a way to automate the execution of those to one file? |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2012-03-29 : 17:22:05
|
| If running from a SQL Agent Job, in the job step, you can modify the destination in the data sources tab |
 |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-03-30 : 18:09:13
|
quote:
Originally posted by WJHamel
i have about 30 SSIS packages that import data from different excel files. Is there a way to automate the execution of those to one file?
why do you need separate package for each?Cant you keep them inside separate data flow tasks inside same package?if you want to keep them in separate packages and call it from single job add a master package which just had execute package task inside a for each loop and make the loop iterate though other packages by creating a ado.net recordset or a list inside------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
execute multiple SSIS packages