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.
We need to have an SSIS project deployed on SSMS from Chapter 9, Deployment.
C:\Program Files\Microsoft SQL Server\110\DTS\Binn