部署SSIS

最新推荐文章于 2021-02-11 11:16:21 发布

wangyanglongcc

最新推荐文章于 2021-02-11 11:16:21 发布

阅读量429

点赞数

分类专栏： SQL Server相关文章标签： sqlserver 数据库

本文链接：https://blog.csdn.net/qq_33246702/article/details/107368145

版权

SQL Server相关专栏收录该内容

31 篇文章 4 订阅

订阅专栏

部署SSIS

USE [SSISDB]
GO

DECLARE @ProjectBinary AS VARBINARY(MAX)
DECLARE @operation_id AS BIGINT
SET @ProjectBinary =
(
SELECT * FROM OPENROWSET
(
BULK 'D:\SSIS\FirstDemo\FirstDemo\bin\Development\FirstDemo.ispac',-- SSIS部署包的路径
SINGLE_BLOB
) AS BinaryData
)
EXEC [catalog].[deploy_project]
@folder_name = 'FirstDemo',-- 在SQL Server中Intergration Services目录\SSISDB中的名称
@project_name = 'FirstDemo',
@Project_Stream = @ProjectBinary,
@operation_id = @operation_id OUT
GO