Orlando Colamatteo (2/3/2016)
SQL_Surfer (2/2/2016)
I've about 200 SSIS packages that needs to be run on 10 different instances. What is the best way to configure this dynamically? Ideally I'd like to store them in CMS server and run them on all the SQL instances that I need. Is this possible? Any suggestions/ideas would be appreciated.Why do they need to run ON the specific instances as opposed to AGAINST the 10 instances? Anything you can do in SSIS to be executed locally can be executed remotely. In theory you can run each Package on a single machine and have it configured to do the necessary work on each of the remote machines. What are these Packages doing?
Great question.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.