How to run two packages at the same time

Chrild Y 20 Reputation points
2023-05-31T05:46:46.6533333+00:00

How to run two packages at the same time?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,345 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,525 questions
0 comments No comments
{count} votes

Accepted answer
  1. ZoeHui-MSFT 35,546 Reputation points
    2023-05-31T06:27:09.7933333+00:00

    Hi @Chrild Y,

    You may create a new package called master package. Inside that package you add 2 tasks called Execute Package Tasks. Then you reference each task to your 2 ssis packages you have created. and then you just run your master package.

    Regards´╝î

    Zoe Hui


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

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Olaf Helper 43,246 Reputation points
    2023-05-31T05:54:21.7166667+00:00

    There are several options

    • Create a SQL Server-Agent for each package, staring at the same time
    • Create a master package with 2 "Execute Package Task" executing the other packages in parallel.
    0 comments No comments