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 |
|
tybaltzeke
Starting Member
28 Posts |
 Posted - 2009-03-27 : 18:42:42
|
| if you have a table telling you which of many packages to run, what's the simplest way to pass that info into SSIS as parameters. are there design issues to consider? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-03-28 : 04:43:23
|
| what you need is to use a recordset variable in ssis to get values from table and then use for each loop with ado.net enumerator to loop through table packages and execute each. |
 |
|
|
|
|
|
multiple packages parameterized by tables