Post reply

SSIS Package Instances

  • March 3, 2012 at 12:45 pm

    #251882

    I wrote an SSIS FTP download utility for a customer. I did it in a generic fashion so that all it needs is a source and a destination, and it will handle the download. Works fine. My question is how will a package behave if there happen to be several instances of that package running? The customer is running the packages as sql server jobs. If they setup say 5 instances of the package pointing at different sources/destinations/schedules is there anything I need to think about having several instances potentially running at once? Honestly I don't think this will happen but I want to be prepared.

    Thanks

    .

  • March 5, 2012 at 12:49 am

    #1454656

    That shouldn't really be a problem, as you're just downloading files.

    If say for example they would write to the same table, you could have concurrency issues.

    The packages will of course compete for the same hardware resources.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • March 5, 2012 at 8:45 pm

    #1455088

    Thanks Koen. That's the answer I was hoping for.

    I know I'm probably not supposed to do this sort of thing, but I noticed your certifications. I need to get my MCSP. I was wondering if you had any advice for study resources. Specifically practice exams. I don't mind paying for them if they are good. If you have any advice, please let me know at bpsavoie@live.com.

    Thanks.

    .

  • March 5, 2012 at 11:02 pm

    #1455107

    I just read the training kits available for the exams, read a lot of blogs/articles and MSDN pages.

    There's a certification forum here at SSC (near the bottom of the list), you probably have more luck finding someone who bought a good practice test.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • March 5, 2012 at 11:08 pm

    #1455113

    the packages should run fine own their own as seperate process. However you might want to consider using checkpoint files to make sure that any unexpected failures in one package doesn't cause issues the running of others. I say this because i assume your using a single configuration file for all the packages.

    Jayanth Kurup[/url]

Viewing 5 posts - 1 through 4 (of 4 total)

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