SQL Server Integration Services (SSIS) DevOps Tools in preview

[Chunhua]

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.

[Jason Kohlhoff]

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

[John_Bailey]

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]

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.