Skip to main content

This quick start demonstrates how to use SQL Server Management Studio (SSMS) to connect to the SSIS Catalog database, and then use Transact-SQL statements to deploy an SSIS project to the SSIS Catalog.

declare @ProjectBinary as varbinary(max);
declare @operation_id as bigint;

set @ProjectBinary = (select * from OPENROWSET(bulk '<project_file_path>.ispac', single_blob) as BinaryData);

exec catalog.deploy_project
    @folder_name = '<target_folder>',
    @project_name = '<project_name',
    @Project_Stream = @ProjectBinary,
    @operation_id = @operation_id out;