Learn more about SQL Server tools

   
   























Latest from MSSQLTips















Command line deployment tool for SSIS packages

(DTUTIL)


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

Explanation
To begin open a Command Prompt and navigate to the Tutorial-Sample-1 project folder as shown below:

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 
       /COPY 
       FILE;C:\temp\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 
       /COPY 
       DTS;CreateSalesForecastInput

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

DTUTIL /FILE CreateSalesForecastInput.dtsx 
       /COPY 
       SQL;CreateSalesForecastInput 

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.

 

 

 

 







 
More SQL Server Solutions



 

Follow

Get Free SQL Tips

Twitter

LinkedIn

Google+

Facebook

Pinterest

RSS

Learning

DBAs

Developers

BI Professionals

Careers

Q and A

Today's Tip

Resources

Tutorials

Webcasts

Whitepapers

Tools

Search

Tip Categories

Search By TipID

Authors

Community

First Timer?

Pictures

Free T-shirt

Contribute

Events

User Groups

Author of the Year

More Info

Join

About

Copyright

Privacy

Disclaimer

Feedback

Advertise

Copyright (c) 2006-2015 Edgewood Solutions, LLC All rights reserved
Some names and products listed are the registered trademarks of their respective owners.