Post reply

SSIS 2014, how to chain execution of 3 packages

  • September 2, 2016 at 3:25 pm

    #313103

    Hi, all

    I have 3 packages (dtsx) which quite big and their dependent on each other ( pack_2 only run if pack_1 completed OK, etc...).

    How I can build kinda master pack with will define all that dependencies, I tried container, but I can't put pack into container.

    Of course I can put content of all Pack_1,2,3 into single packgage but It will be too much I think, I believe they were broken already from single package for easy maintain.

    Or there is some kind of triger in Toolbox which I can put at the very end and trigger another package ??

    Thanks for info

    Mario

  • September 2, 2016 at 3:41 pm

    #1899061

    I would create a new package executes each of these packages in the required sequence.


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • September 2, 2016 at 4:04 pm

    #1899063

    Thanks Alvin,

    I found and testing | Execute Package Task | component which should work OK>. I don't see any drawback for using it.

    Is this what you mean ?

    Bets

    M

Viewing 3 posts - 1 through 2 (of 2 total)

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