Execution from a command-line utility

Execution of a package from SSMS is very easy and handy, but there are many cases where you might want to execute a package from the command line in silent mode, or you may want to run it from an external application or you may want to run some SSIS packages within a batch file. SSIS provides a Command Line Utility to support such cases and execute a package without need of any specific GUI.

In this recipe we will execute a package from the Command Line Utility and will discuss different options for execution.

Getting ready

We need to have an SSIS project deployed on SSMS from Chapter 9, Deployment.

How to do it...

1. Open the Command Prompt and go to this path:

   C:\Program Files\Microsoft SQL Server\110\DTS\Binn

   And run this command:

   DTExec /?
   

   

2. Then run this command:

   DTExec /SQL P02_Child
   

   P02_Child package will be run and its execution log will appear in the command prompt window. This command runs a package from SQL Server storage.

3. Then run the following command...