SQL Server Integration Services (SSIS) DevOps Tools in preview

Published Dec 05 2019 04:21 PM 5,283 Views
Microsoft

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-build-task.png

  • 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-deploy-task.png

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

ssis-catalog-configuation-task.png

 

Please refer to this page for more detail usage.

3 Comments
New Contributor

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

Occasional Visitor

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'

Microsoft

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.

%3CLINGO-SUB%20id%3D%22lingo-sub-1057985%22%20slang%3D%22en-US%22%3ERe%3A%20SQL%20Server%20Integration%20Services%20(SSIS)%20DevOps%20Tools%20is%20released%20in%20preview%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1057985%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20is%20fantastic!%26nbsp%3B%20Thanks%20so%20much%20for%20making%20these%20long%20overdue%20tasks%20available!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1051744%22%20slang%3D%22en-US%22%3ESQL%20Server%20Integration%20Services%20(SSIS)%20DevOps%20Tools%20in%20preview%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1051744%22%20slang%3D%22en-US%22%3E%3CP%20style%3D%22box-sizing%3A%20inherit%3B%20color%3A%20%23171717%3B%20font-family%3A%20Segoe%20UI%2CSegoeUI%2CSegoe%20WP%2CHelvetica%20Neue%2CHelvetica%2CTahoma%2CArial%2Csans-serif%3B%20font-size%3A%2016px%3B%20font-style%3A%20normal%3B%20font-variant%3A%20normal%3B%20font-weight%3A%20400%3B%20letter-spacing%3A%20normal%3B%20orphans%3A%202%3B%20overflow-wrap%3A%20break-word%3B%20text-align%3A%20left%3B%20text-decoration%3A%20none%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20-webkit-text-stroke-width%3A%200px%3B%20white-space%3A%20normal%3B%20word-spacing%3A%200px%3B%20padding%3A%200px%3B%20margin%3A%201rem%200px%200px%200px%3B%22%3E%3CA%20title%3D%22SSIS%20DevOps%20Tools%22%20href%3D%22https%3A%2F%2Fmarketplace.visualstudio.com%2Fitems%3FitemName%3DSSIS.ssis-devops-tools%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3E%3CSTRONG%20style%3D%22box-sizing%3A%20inherit%3B%20font-weight%3A%20bolder%3B%22%3ESSIS%20DevOps%20Tools%3C%2FSTRONG%3E%20%3C%2FA%3Eextension%20is%20now%20in%20preview.%3C%2FP%3E%0A%3CP%20style%3D%22box-sizing%3A%20inherit%3B%20color%3A%20%23171717%3B%20font-family%3A%20Segoe%20UI%2CSegoeUI%2CSegoe%20WP%2CHelvetica%20Neue%2CHelvetica%2CTahoma%2CArial%2Csans-serif%3B%20font-size%3A%2016px%3B%20font-style%3A%20normal%3B%20font-variant%3A%20normal%3B%20font-weight%3A%20400%3B%20letter-spacing%3A%20normal%3B%20orphans%3A%202%3B%20overflow-wrap%3A%20break-word%3B%20text-align%3A%20left%3B%20text-decoration%3A%20none%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20-webkit-text-stroke-width%3A%200px%3B%20white-space%3A%20normal%3B%20word-spacing%3A%200px%3B%20padding%3A%200px%3B%20margin%3A%201rem%200px%200px%200px%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20style%3D%22box-sizing%3A%20inherit%3B%20color%3A%20%23171717%3B%20font-family%3A%20Segoe%20UI%2CSegoeUI%2CSegoe%20WP%2CHelvetica%20Neue%2CHelvetica%2CTahoma%2CArial%2Csans-serif%3B%20font-size%3A%2016px%3B%20font-style%3A%20normal%3B%20font-variant%3A%20normal%3B%20font-weight%3A%20400%3B%20letter-spacing%3A%20normal%3B%20orphans%3A%202%3B%20overflow-wrap%3A%20break-word%3B%20text-align%3A%20left%3B%20text-decoration%3A%20none%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20-webkit-text-stroke-width%3A%200px%3B%20white-space%3A%20normal%3B%20word-spacing%3A%200px%3B%20padding%3A%200px%3B%20margin%3A%201rem%200px%200px%200px%3B%22%3E%3CFONT%20size%3D%223%22%3E%3CSTRONG%20style%3D%22box-sizing%3A%20inherit%3B%20font-weight%3A%20bolder%3B%22%3ESSIS%20DevOps%20Tools%3C%2FSTRONG%3E%20includes%20%3CSTRONG%20style%3D%22box-sizing%3A%20inherit%3B%20font-weight%3A%20bolder%3B%22%3ESSIS%20Build%3C%2FSTRONG%3E%20task%2C%20%3CSTRONG%20style%3D%22box-sizing%3A%20inherit%3B%20font-weight%3A%20bolder%3B%22%3ESSIS%20Deploy%3C%2FSTRONG%3E%20release%20task%2C%20and%20%3CSTRONG%3ESSIS%20Catalog%20Configuration%3C%2FSTRONG%3E%20task%3A%3C%2FFONT%3E%3C%2FP%3E%0A%3CUL%20style%3D%22box-sizing%3A%20inherit%3B%20color%3A%20%23171717%3B%20font-family%3A%20Segoe%20UI%2CSegoeUI%2CSegoe%20WP%2CHelvetica%20Neue%2CHelvetica%2CTahoma%2CArial%2Csans-serif%3B%20font-size%3A%2016px%3B%20font-style%3A%20normal%3B%20font-variant%3A%20normal%3B%20font-weight%3A%20400%3B%20letter-spacing%3A%20normal%3B%20list-style-image%3A%20none%3B%20list-style-position%3A%20outside%3B%20list-style-type%3A%20none%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-decoration%3A%20none%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20-webkit-text-stroke-width%3A%200px%3B%20white-space%3A%20normal%3B%20word-spacing%3A%200px%3B%20padding%3A%200px%3B%20margin%3A%2016px%200px%2016px%2038px%3B%22%3E%0A%3CLI%20style%3D%22box-sizing%3A%20inherit%3B%20list-style-image%3A%20none%3B%20list-style-position%3A%20outside%3B%20list-style-type%3A%20disc%3B%20outline-color%3A%20invert%3B%20outline-style%3A%20none%3B%20outline-width%3A%200px%3B%20padding%3A%200px%3B%20margin%3A%200px%3B%22%3E%3CP%20style%3D%22box-sizing%3A%20inherit%3B%20overflow-wrap%3A%20break-word%3B%20padding%3A%200px%3B%20margin%3A%201rem%200px%200px%200px%3B%22%3E%3CFONT%20size%3D%223%22%3ESSIS%20Build%20task%20supports%20building%20dtproj%20files%20in%20project%20deployment%20model%20or%20package%20deployment%20model.%3C%2FFONT%3E%3C%2FP%3E%0A%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22ssis-build-task.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F160332iD46AF7D152DEC81B%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22ssis-build-task.png%22%20alt%3D%22ssis-build-task.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CUL%20style%3D%22box-sizing%3A%20inherit%3B%20color%3A%20%23171717%3B%20font-family%3A%20Segoe%20UI%2CSegoeUI%2CSegoe%20WP%2CHelvetica%20Neue%2CHelvetica%2CTahoma%2CArial%2Csans-serif%3B%20font-size%3A%2016px%3B%20font-style%3A%20normal%3B%20font-variant%3A%20normal%3B%20font-weight%3A%20400%3B%20letter-spacing%3A%20normal%3B%20list-style-image%3A%20none%3B%20list-style-position%3A%20outside%3B%20list-style-type%3A%20none%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-decoration%3A%20none%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20-webkit-text-stroke-width%3A%200px%3B%20white-space%3A%20normal%3B%20word-spacing%3A%200px%3B%20padding%3A%200px%3B%20margin%3A%2016px%200px%2016px%2038px%3B%22%3E%0A%3CLI%20style%3D%22box-sizing%3A%20inherit%3B%20list-style-image%3A%20none%3B%20list-style-position%3A%20outside%3B%20list-style-type%3A%20disc%3B%20outline-color%3A%20invert%3B%20outline-style%3A%20none%3B%20outline-width%3A%200px%3B%20padding%3A%200px%3B%20margin%3A%200px%3B%22%3E%3CP%20style%3D%22box-sizing%3A%20inherit%3B%20overflow-wrap%3A%20break-word%3B%20padding%3A%200px%3B%20margin%3A%201rem%200px%200px%200px%3B%22%3E%3CFONT%20size%3D%223%22%3ESSIS%20Deploy%20task%20supports%20deploying%20single%20or%20multiple%20ispac%20files%20to%20on-premises%20SSIS%20catalog%20and%20Azure-SSIS%20IR%2C%20or%20SSISDeploymentManifest%20files%20and%20their%20associated%20files%20to%20on-premises%20or%20Azure%20file%20share.%3C%2FFONT%3E%3C%2FP%3E%0A%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22ssis-deploy-task.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F160333i5E074BAE7BF9D4B4%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22ssis-deploy-task.png%22%20alt%3D%22ssis-deploy-task.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3ESSIS%20Catalog%20Configuration%20task%20supports%20configuring%20folder%2Fproject%2Fenvironment%20of%20SSIS%20Catalog%20with%20a%20configuration%20file%20in%20JSON%20format.%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22ssis-catalog-configuation-task.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F180814i70D2227C31CB1E8F%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22ssis-catalog-configuation-task.png%22%20alt%3D%22ssis-catalog-configuation-task.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EP%3CFONT%20size%3D%223%22%20style%3D%22box-sizing%3A%20border-box%3B%22%3Elease%20refer%20to%20this%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fsql%2Fintegration-services%2Fdevops%2Fssis-devops-overview%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3Epage%3C%2FA%3E%20for%20more%20detail%20usage.%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-1051744%22%20slang%3D%22en-US%22%3E%3CP%3EAnnouncing%20preview%20of%20SQL%20Server%20Integration%20Services%20(SSIS)%20DevOps%20Tools.%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2591679%22%20slang%3D%22en-US%22%3ERe%3A%20SQL%20Server%20Integration%20Services%20(SSIS)%20DevOps%20Tools%20in%20preview%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2591679%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20is%20great%2C%20but%20when%20I%20try%20to%20upload%20the%20extension%20to%20my%20on%20premise%20Azure%20Devops%20server%20I%20get%20an%20error%20that%20the%20size%20is%20too%20large.%26nbsp%3B%20Any%20good%20way%20around%20that%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EThe%20extension%20package%20size%20'26269723%20bytes'%20exceeds%20the%20maximum%20package%20size%20'26214400%20bytes'%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Version history
Last update:
‎May 08 2020 06:48 PM
Updated by: