catalog.deploy_project (SSISDB Database)

  • Article

Deploys a project to a folder in the Integration Services catalog or updates an existing project that has been deployed previously.

Syntax

deploy_project [ @folder_name = ] folder_name 
      , [ @project_name = ] project_name 
      , [ @project_stream = ] projectstream 
    [ , [@operation_id ] = operation_id OUTPUT ]

Arguments

  • [ @folder\_name = ] folder_name
    The name of the folder where the project will be deployed to. The folder_name is nvarchar(128).

  • [ @project\_name = ] project_name
    The name of the new or updated project in the folder. The project_name is nvarchar(128).

  • [ @projectstream = ] projectstream
    The binary contents of an Integration Services project deployment file (.ispac extension).

    You can use a SELECT statement with the OPENROWSET function and the BULK rowset provider to retrieve the binary contents of the file. For an example, see Deploy and Execute SSIS Packages using Stored Procedures. For more information about OPENROWSET, see OPENROWSET (Transact-SQL).

    The projectstream is varbinary(MAX)

  • [ @operation\_id = ] operation_id
    Returns the unique identifier for the deployment operation. The operation_id is bigint.

Return Code Value

0 (success)

Result Sets

None

Permissions

This stored procedure requires one of the following permissions:

  • CREATE_OBJECTS permissions on the folder to deploy a new project or MODIFY permissions on the project to update a project

  • Membership to the ssis_admin database role

  • Membership to the sysadmin server role

Errors and Warnings

The following list describes some conditions that may cause this stored procedure to raise an error:

  • A parameter refers to an object that does not exist, a parameter tries to create an object that already exists, or a parameter is invalid in some other way

  • The value of the parameter @project\_name does not match the name of the project in the deployment file

  • The user does not have sufficient permissions

Remarks

During a project deployment or update, the stored procedure does not check the protection level of individual packages in the project.