博客园  :: 首页  :: 新随笔  :: 联系 :: 订阅 订阅  :: 管理

重新注册SSIS

Posted on 2016-08-02 16:38  first_start  阅读(112)  评论(0)    收藏  举报

DECLARE @ProjectBinary as varbinary(max) DECLARE @operation_id as bigint Set @ProjectBinary = (SELECT * FROM OPENROWSET(BULK 'C:\B-DashProject\B-DashProject\bin\Development\B-DashProject.ispac', SINGLE_BLOB) as BinaryData) Exec SSISDB.catalog.deploy_project @folder_name = 'B-DashProject', @project_name = 'B-DashProject', @Project_Stream = @ProjectBinary, @operation_id = @operation_id out