catalog.deploy_project (SSISDB Database)
THIS TOPIC APPLIES TO: SQL Server (starting with 2012) Azure SQL Database Azure SQL Data Warehouse Parallel Data Warehouse
Deploys a project to a folder in the Integration Services catalog or updates an existing project that has been deployed previously.
- [ @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.