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

Question

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

Answer 1

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.

Answer 2

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.