Post reply

Calling an SSIS package from SSIS

  • July 3, 2012 at 8:44 am

    #277384

    Hi,

    Does anyone have any tips on calling an SSIS package (that requires the connections to be set via a config file) from and existing SSIS package?

    At the moment I'm using an 'Execute Package Task' but because the connections are set within the package I'm calling, it's only runnable in one environment.

    Thanks

  • July 3, 2012 at 9:13 am

    #1508287

    Also, I'd add.. the original package wont know which package it's running until it gets to a certain point. The name and location of the subsiquent package will be written to variables in the original package.

    I can run it if I hard code the connections in the packages I need to call but that's not an option.

  • July 4, 2012 at 12:28 am

    #1508600

    You could use an Execute Process Task to call a package using DTEXEC.

    In the DTEXEC command, you can specify a config file.

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

  • July 4, 2012 at 4:41 am

    #1508684

    Thanks Koen, I'll give it a try and report back !

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

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