Command line deployment tool for SSIS packages


SQL Server includes the command line tool DTUTIL.EXE which can be used to deploy SSIS packages.  DTUTIL is a good choice when you want to script out the deployment of SSIS packages.  DTUTIL can be executed 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:

ommand prompt

In the examples that follow, I will show how to deploy the CreateSalesForecastInput.dtsx package to the file system, package store, and SQL Server.

To deploy to the file system, you could use the DOS COPY command, Windows Explorer, etc. or the following DTUTIL command (all on one line):

DTUTIL /FILE CreateSalesForecastInput.dtsx 

Replace the path C:\temp as appropriate.

To deploy to the package store, type the following command (all on one line):

DTUTIL /FILE CreateSalesForecastInput.dtsx 

 To deploy to SQL Server, type the following command (all on one line):

DTUTIL /FILE CreateSalesForecastInput.dtsx 

The above command deploys to the default SQL Server instance on the local machine.  To deploy to a different SQL Server add the command line parameter /DESTSERVER "SERVERNAME\INSTANCENAME".

Additional Information

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





Comments For This Article

Tuesday, May 30, 2023 - 9:05:47 AM - RAYMOND BARLEY Back To Top (91234)
Since SQL Server 2012, the preferred deployment model is Project deployment which uses the SSIS Catalog. As best I can tell I don't think DTUTIL supports that. Here is a tip that will get you started on the Project deployment:

Sunday, May 28, 2023 - 9:18:06 AM - DODER Back To Top (91231)
single command did not work.

get free sql tips
agree to terms