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.dtsxTo see the complete list of command line options for DTEXEC type:
DTEXEC /?Additional Information
- Take a look at the DTEXEC command in Books Online for additional details.
Ray is a Principal Architect at IT Resource Partners focused on SQL Server and Business Intelligence. He is a Microsoft Certified Solutions Expert (MCSE) in Business Intelligence, a MSSQLTips.com BI Expert and Ambassador. He is also a co-author of the book: SharePoint 2010 Business Intelligence Unleashed.
- MSSQLTips Awards: Champion (100+ tips)
