Deployment - SQL Server Integration Services Design Patterns - page 438

Parameter Short

Version

Description

SourceType: {File|Server} ST This option specifies whether the source pro-

ject comes from the file system, or another
SSIS Catalog. The default value is “File.”
Example: /SourceType:File

SourcePath: path_to_project SP The path to the .ispac file being deployed

(when using the File source), or the path to
the project name (when using the Server
source).
Example: /SourcePath:C:\ETL\project.ispac

SourceServer: server_instance SS The name of the server instance when the

SourceType is set to Server.
Example: /SourceServer:localhost\SQL1

ProjectPassword: password PP If the source .ispac file is password protected,

this parameter can be used to supply the pass-
word. Note that specifying a password on the
command line is not recommended, as other
users on the system might be able to see the
arguments. If your project file is using pass-
word encryption, consider specifying the
password in the response file (see the
@<file> option for more information)

DestinationServer: server_instance DS The name of the server instance you are de-

ploying to.
Example: /DestinationServer:localhost

DestinationPath: path DP The path you want to deploy the project to on

the destination server. The format of the path
is “/<catalog>/<folder>/<project>”.
Example: /DestinationPath:/SSISDB/
MyFolder/Project

@<file> This option allows you to specify all of your

command line arguments in a text file, in-
stead of entering them directly on the com-
mand line.
Example: @arguments.txt

Listing 18-1 . Deploying a project from the command line