Run an SSIS package from the command prompt with DTExec.exe
Applies to: SQL Server SSIS Integration Runtime in Azure Data Factory
This quickstart demonstrates how to run an SSIS package from the command prompt by running
DTExec.exe with the appropriate parameters.
The method described in this article has not been tested with packages deployed to an Azure SQL Database server.
For more info about
DTExec.exe, see dtexec Utility.
You can use the information in this quickstart to run an SSIS package on the following platforms:
- SQL Server on Windows.
The method described in this article has not been tested with packages deployed to an Azure SQL Database server. For more info about deploying and running packages in Azure, see Lift and shift SQL Server Integration Services workloads to the cloud.
You cannot use the information in this quickstart to run an SSIS package on Linux. For more info about running packages on Linux, see Extract, transform, and load data on Linux with SSIS.
Run a package with dtexec
If the folder that contains
DTExec.exe is not in your
path environment variable, you may have to use the
cd command to change to its directory. For SQL Server 2017, this folder is typically
C:\Program Files (x86)\Microsoft SQL Server\140\DTS\Binn.
With the parameter values used in the following example, the program runs the package in the specified folder path on the SSIS server - that is, the server that hosts the SSIS Catalog database (SSISDB). The
/Server parameter provides the server name. The program connects as the current user with Windows Integrated Authentication. To use SQL Authentication, specify the
Password parameters with appropriate values.
Open a Command Prompt window.
DTExec.exeand provide values at least for the
Serverparameters, as shown in the following example:
dtexec /ISServer "\SSISDB\Project1Folder\Integration Services Project1\Package.dtsx" /Server "localhost"