Create action in Windows Task Scheduler run commands for dtsx packages

Question

I am wondering the correct way to navigate to a dtsx package deployed on my SQL Server. While creating the action, so far I have the Program/script to open SQL.

"CD\C\Program Files (x86)Microsoft SQL Server\140\Tools\Binn|ManagementStudio\DTExecUI.exe"

My issue is finding the path to the package that is deployed. What arguments can I add to continue navigating through the packages in the SSIS catalog?

Answer 1

First of all, i think that it is better to work with SQL server agent to schedule a ssis package job

---

To run a package from a server using Task scheduler, you can use DTExec utility.

example

dtexec /ISServer "\SSISDB\Project1Folder\Integration Services Project1\Package.dtsx" /Server "localhost"

References

• Run an SSIS package from the command prompt with DTExec.exe
• Scheduling SQL Server Integration Services Packages.
• dtexec utility
• Usin dtexec with package on IS Server