Command line tool to execute SSIS packages
By: Ray Barley
SQL Server includes the command line tool DTEXEC.EXE which can be used to execute an SSIS package. DTEXEC can be run from a Command Prompt or from a batch (.BAT) file.
To begin open a Command Prompt and navigate to the Tutorial-Sample-1 project folder as shown below:
It is not necessary to run DTEXEC from the folder where the SSIS package is located; it's just easier to change to the directory for demonstration purposes. Type the following command to execute the CreateSalesForecastInput.dtsx package:
DTEXEC /FILE CreateSalesForecastInput.dtsx
To see the complete list of command line options for DTEXEC type:
- Take a look at the DTEXEC command in Books on Line for additional details.