Deployment - SQL Server Integration Services Design Patterns - page 437

Note More information about package protection levels and secure deployments can
be found in Books Online at http://msdn.microsoft.com/en-us/lib-
rary/bb522558.aspx .

Deployment Methods

This section describes the different deployment methods supported by the SSIS Cata-
log. The method you choose will depend on your environment, and what the people do-
ing the deployment - whether they are developers, ETL operators, or DBAs - are most
comfortable with. The deployment methods described here include:

• Deployment from the command line

• Deployment using custom code
• Deployment using PowerShell
• Deployment using SQL

Deployment from the Command Line

The Deployment Wizard (ISDeploymentWizard.exe) provides a command line inter-
face, which allows you to deploy to the SSIS Catalog without a UI. This is very useful
for deploying from scripts, or as part of a batch process. Table 18-1 shows the list of
supported parameters. Listing 18-1 provides an example command line that deploys a
project (C:\ETL\Project.ispac) to a folder named MyFolder on a local SSIS Catalog.

Table 18-1 . Integration Services Deployment Wizard command line parameters

Parameter Short

Version

Description

Silent[+|-] S When this option is true, the deployment will

be done in a UI-less mode (command line
only). Use this option when deploying from
batch files. The default value is '-', which
will display the UI.
Example: /Silent+