Post reply

Is it possible to link multiple SSIS packages in one package

  • November 9, 2009 at 5:38 am

    #137263

    Hi,

    Is it possible to link multiple SSIS packages in one package, and just execute the single package?

    :unsure:

    If yes, how is it done?

    The other question is, if one of the packages is it changed, will it be automatically changed in all packages it is linked to?

    :unsure:

    Thanks in advance.

    Regards,

  • November 9, 2009 at 7:37 am

    #1076646

    You can use the Execute Package task to execute other SSIS packages.

    So long as you update the referenced copy of the package, yes, it will stay synchronized. (Since you can save a package to the disk or export it into msdb, you have to make sure you're updating it in the right place.)

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • November 11, 2009 at 12:56 am

    #1077664

    Thanks for your answer, :Wow: I will try it right away.

    Regards,

    MrAkki

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

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