InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 20 May 2013 11:20:55 GMT20http://www.sqlservercentral.com/Forums/Topic1391719-391-1.aspx[quote][b]sagar0838 (12/2/2012)[/b][hr]I have 15 packages in dev server , at first instance we need to execute 7 and next 8 in the second instance[/quote]Are you saying you need to move 7 of these jobs to one server and 8 to another? If so, copy the .dtsx packages to the appropriate servers and create SQL Agent jobs on each server to run the jobs.HTH,RobSun, 02 Dec 2012 18:00:14 GMTrobert.gerald.taylorhttp://www.sqlservercentral.com/Forums/Topic1391719-391-1.aspxI have 15 packages in dev server , at first instance we need to execute 7 and next 8 in the second instanceSun, 02 Dec 2012 06:26:50 GMTsagar0838