Command line tool to execute SSIS packages



By:

Overview
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.

Explanation
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:

DTEXEC /? 

Additional Information

  • Take a look at the DTEXEC command in Books on Line for additional details.

 

 

 

 


Last Update: 10/22/2009






Comments For This Article





download


get free sql tips
agree to terms


Learn more about SQL Server tools