catalog.deploy_project (SSISDB Database)

SQL Server 2012

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

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

[ @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.

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

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

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

Community Additions