Blog Post

SQL Server Integration Services (SSIS) Blog
1 MIN READ

SQL Server Integration Services (SSIS) DevOps Tools in preview

Chunhua's avatar
Chunhua
Icon for Microsoft rankMicrosoft
Dec 06, 2019

SSIS DevOps Tools extension is now in preview.

 

SSIS DevOps Tools includes SSIS Build task, SSIS Deploy release task, and SSIS Catalog Configuration task:

  • SSIS Build task supports building dtproj files in project deployment model or package deployment model.

  • SSIS Deploy task supports deploying single or multiple ispac files to on-premises SSIS catalog and Azure-SSIS IR, or SSISDeploymentManifest files and their associated files to on-premises or Azure file share.

  • SSIS Catalog Configuration task supports configuring folder/project/environment of SSIS Catalog with a configuration file in JSON format.

 

Please refer to this page for more detail usage.

Updated May 09, 2020
Version 4.0
  • Jason Kohlhoff's avatar
    Jason Kohlhoff
    Brass Contributor
    Dec 10, 2019

    This is fantastic!  Thanks so much for making these long overdue tasks available!

  • John_Bailey's avatar
    John_Bailey
    Copper Contributor
    Jul 27, 2021

    This is great, but when I try to upload the extension to my on premise Azure Devops server I get an error that the size is too large.  Any good way around that?

     

    The extension package size '26269723 bytes' exceeds the maximum package size '26214400 bytes'

  • Chunhua's avatar
    Chunhua
    Icon for Microsoft rankMicrosoft
    Jul 27, 2021

    Refer to answer in extension Q & A 

    If you receive the error "The extension package size '26272573 bytes' exceeds the maximum package size '26214400 bytes'" while trying to install this extension (starting with version 1.0.4.3) on Azure DevOps Server on premise, you need to run the following T-SQL command in the configuration database of your Azure DevOps Server instance (default DB name: Tfs_Configuration):

     

    EXEC dbo.prc_SetRegistryValue @partitionId = 1, @key = '#\Configuration\Service\Gallery\LargeExtensionUpload\MaxPackageSizeMB\', @value = 50, @identityName = null

     

    After running this statement you need to restart the IIS service.