none
Can we deploy multiple SSIS projects in single deployment using TFS

    Question

  • Hi,

    We are currently using TFS to deploy our SSIS projects individually. each project will have atleast 4 to 5 dtsx packages. Is there a way we can deploy multiple projects in one go instead of deploying individual packages? 


    Aparanjit

    Tuesday, May 21, 2019 8:36 PM

Answers

  • Hi Rahul 11,

    1.According to your issue, we could Deploy an SSIS project from SSMS with Transact-SQL.

    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

    2.We could also refer to the following link.

    Deploy Multiple SQL Server Integration Services SSIS Projects Using C#

    Best Regards,

    Mona Lv


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Wednesday, May 22, 2019 4:55 AM

All replies

  • Hi Aparanjit,

    Starting with SQL Server 2012 and later, SSIS has 'Project Deployment' mode.

    It seems this is exactly what you need.

    Tuesday, May 21, 2019 10:44 PM
  • Hi,

    For the project deployment we can deploy only one project at a time, but we have around 10 projects for each release and we had to deploy each project individually.

    But we are looking for something, where we can select all the projects we need and deploy it at once on to the selected server (QA/UAT).


    Aparanjit

    Wednesday, May 22, 2019 1:27 AM
  • Hi Rahul 11,

    1.According to your issue, we could Deploy an SSIS project from SSMS with Transact-SQL.

    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

    2.We could also refer to the following link.

    Deploy Multiple SQL Server Integration Services SSIS Projects Using C#

    Best Regards,

    Mona Lv


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Wednesday, May 22, 2019 4:55 AM