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 |
|
jbates99
Constraint Violating Yak Guru
396 Posts |
 Posted - 2012-08-20 : 17:47:17
|
| hi,I have a 2008 server that has 3 named instances. So it has 3 data engines, 3 job agents - but only 1 Integration Services service.To be able to run an SSIS package against any of the 3 instances -- would I have to build 3 separate packages and in each one reference the appropriate connection manager that would point to that db instance? Any other way?Thanks, John |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-08-20 : 17:50:13
|
| nope. you just have to create single SSIS package and store in file system. then call it from sql serger agents on 3 instances to execute. if it needs to access data from any of db make sure you make configuration items for connection manager connection string properties and set correct values from the sql jobs------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
jbates99
Constraint Violating Yak Guru
396 Posts |
Posted - 2012-08-20 : 18:01:29
|
| Thankyou, Visakhm.I will explore your ideas. I may have to post back with a followup question.John |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-08-20 : 18:46:37
|
| ok...npFeel free to post if you need any further clarification------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Using SSIS on a Multi-Instance Server