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

YASHODHAN P JOSHI 1 Reputation point
2022-08-30T05:24:19.867+00:00

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.
1,950 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,055 questions
No comments
{count} votes

2 answers

Sort by: Most helpful
  1. ZoeHui-MSFT 20,101 Reputation points
    2022-08-30T05:50:52.33+00:00

    Hi @YASHODHAN P JOSHI ,

    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.

    Regards´╝î

    Zoe Hui


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


  2. Olaf Helper 27,211 Reputation points
    2022-09-05T05:40:51.337+00:00

    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.