Learn more about SQL Server tools

   
   




























Connect with MSSQLTips




MSSQLTips Facebook Page MSSQLTips LinkedIn Page MSSQLTips RSS Feed MSSQLTips Pinterest Page MSSQLTips Twitter Page MSSQLTips Google+ Page


Command line tool to execute SSIS packages  
(DTEXEC)

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.

 

 

 

 



 
Sponsor Information