Search code examples
sql-serverssisetlsql-server-data-toolsssis-2012

Run multiple .dtsx files together

I have three different .dtsx packages under a single ssis package. How to execute all three together with a single click without having to open each dtsx file and execute them separately

Solution

  • Steps to execute three different .dtsx packages under a single ssis package.

    1. Create a package and drag a sequence container into the package.
    2. Inside sequence container Drag and drop three Execute Package Task.
    3. Map all three Execute Package Task with respected .dtsx package.
    4. Execute the sequence container.

    Execution process:

    enter image description here

    enter image description here