Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Running SSIS packages Expand / Collapse
Author
Message
Posted Sunday, December 2, 2012 6:26 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, June 21, 2013 5:56 AM
Points: 18, Visits: 99

I have 15 packages in dev server , at first instance we need to execute 7 and next 8 in the second instance
Post #1391719
Posted Sunday, December 2, 2012 6:00 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 7:50 AM
Points: 1,234, Visits: 1,273
sagar0838 (12/2/2012)

I have 15 packages in dev server , at first instance we need to execute 7 and next 8 in the second instance


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,
Rob
Post #1391754
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse