Problem in executing SSIS packages

Question

I created two instances of SQL Server on my server. Project1 and Projec2

both these projects have ssis packages which have been stored in respective msdb.

I want the ability to execute the packages... but it seems that SSIS does not support multi-instance.

So how can I execute these packages in a multi isntance scenario?

---

MSDNStudent Knows not much!

Answer 1

http://www.sqlmag.com/forums/aft/80083

---

Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

Answer 2

Create SQL Agent jobs for the SSIS packages and then you should be able to access the other remote instance using a Linked server to execure the sp_start_job

HTH

---

Regards, Ashwin Menon My Blog - http:\\sqllearnings.com