How to execute a package from the integration services catalog?

Problem: How to execute a package from the integration services catalog?

Solution: Run Integration Services (SSIS) Packages

There are few ways to run the package of a deployed package from Integration services catalog.

      1.       SQL Server management studio when it’s connected to integration services catalog.
2.       SQL Server Agent.
3.       DTEXEC
4.       DTEXECUI

Example:

In this article, I am going to show we can use DTEXEC to execute the integration services catalog package.

In my environment, I have few versions of SQL Server like 2008,2012,2014 and 2016.

Step 0: Go to the SQL Server Version of where the packages has been deployed. In my case I have the packages built in SQL Server 2014. So I have to point in the 120 compatibility level

For ex: C:\Program Files\Microsoft SQL Server\120\DTS\Binn

Step 1: from this folder launch the DTEXEC.exe using the command line prompt from the drive location above.

Step 2:  Pass the arguments to execute the file name passing /F as argument project location from the SSIS solution folder.

C:\Program Files\Microsoft SQL Server\110\DTS\Binn>DTExec.exe /F "C:\SSIS\BlogPr

ojects\BlogProjects\Merge.dtsx"

Results:

C:\Program Files\Microsoft SQL Server\120\DTS\Binn>DTExec.exe /F "C:\SSIS\BlogPr

ojects\BlogProjects\Merge.dtsx"

Microsoft (R) SQL Server Execute Package Utility

Version 12.0.5000.0 for 64-bit

Copyright (C) Microsoft Corporation. All rights reserved.

Started:  10:28:25 PM

Progress: 2017-06-21 22:28:25.64

   Source: Data Flow Task

   Validating: 0% complete

End Progress

   Validating: 71% complete

End Progress

Progress: 2017-06-21 22:28:25.70

   Source: Data Flow Task

   Validating: 85% complete

End Progress

…End Progress

Started:  10:28:25 PM

Finished: 10:28:25 PM

Elapsed:  0.406 seconds