DTUTIL—the command-line utility for deployment

Package Deployment Model is based on packages and this means that every package should be deployed independently, but Deployment Utility can help to create one setup kit for all packages. Deployment Utility is helpful but it needs a user who is familiar with SSIS to choose destination type, set server properties, and other things which were in Package Installation Wizard. There should be a method to deploy everything without interaction with the user in silent mode.

Fortunately, SSIS provides a command-line utility—DTUTIL.exe—for Package Deployment Model. We can write statements on DTUTIL to deploy packages in silent mode.

In this recipe, we take a look at how to deploy packages with DTUTIL.

How to do it...

1. Open the command-prompt window and go to the following path in the command prompt:

   C:\Program Files\Microsoft SQL Server\110\DTS\Binn
   

2. Type the following command:

   DTUTIL /? 
   

   

3. A list of switches for DTUTIL will appear.

4. Now enter the following command...