how to select multiple dtdx file while setup server job for SSIS package in sql server

YASHODHAN P JOSHI 1 Reputation point

I'm having multiple dtdx files in one project so I want to setup job for all of them , so I want to select multiple files at a same time

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,464 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,249 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. ZoeHui-MSFT 33,386 Reputation points


    You may try with below steps:

    1.Create one SSIS package which is executed by ONE sql agent job. lets call this 'PackageExecution.dtsx'.

    2.PackageExection then contains multiple Execute Package tasks for the packages you want to execute.

    3.In the package you can apply any package execution rules - which packages have to run after the other, which packages can run concurrently, which packages should only run if previous succeeded.

    4.Schedule agent job for PackageExecution.dtsx.

    If you need to change the sequence, just update the PackageExecution package.

    So that you could set one agent job to run multiple packages.


    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.

  2. Olaf Helper 41,021 Reputation points

    so I want to select multiple files at a same time

    If you mean for a SQL Server-Agent job, it's not possible, you have to setup one-by-one.

    0 comments No comments