Post reply

Scheduling SSIS packages across instances

  • October 29, 2008 at 10:01 pm

    #127331

    Hello Everyone,

    I have an SSIS package that runs across 4 different SS2005 instances. Currently, we are running this package manually. I would really like to create a job that runs it on a schedule, but I seem to be having an issues with it.

    I have almost no experience with SSIS and running them across multiple instances, so I am wondering at this point, can this be done? If so, where do I start. If not, what are my other options.

    Thanks everyone,

    Fraggle

  • October 31, 2008 at 11:26 am

    #892485

    create job for each instance and schedule it

    for example....

    1. Job1 on Instance1 schedule to run at 1 PM

    2. Job2 on Instance2 schedule to run at 2 PM

    etcc...

  • October 31, 2008 at 11:35 am

    #892487

    Sorry, forgot to mention that the instances are on different servers.

    And all I am doing is moving data from server1.instance1.table to server2.instance2.table

    Sorry about the confusion.

    Fraggle

  • October 31, 2008 at 11:43 am

    #892490

    you can schedule all the packages on one server or different.

  • October 31, 2008 at 11:53 am

    #892492

    So you are saying I can create 1 job to run at 12am on server 1 that will transfer the data to server 2,3,4.......?

    Am I understanding you correctly?

    Fraggle

  • October 31, 2008 at 1:58 pm

    #892569

    yes

  • October 31, 2008 at 2:04 pm

    #892573

    Sweet, now if I can just firgure out why I get an error message stating "unable to load package as XML because package does not have a valid XML format". I will be able to stop running this thing manually 2x a month.

    Thanks,

    Fraggle

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply