SQL Server Integration Services (SSIS) DevOps Tools in preview

Published Dec 05 2019 04:21 PM 6,679 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
%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%3CLINGO-SUB%20id%3D%22lingo-sub-2593442%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-2593442%22%20slang%3D%22en-US%22%3E%3CP%3ERefer%20to%20answer%20in%20%3CA%20href%3D%22https%3A%2F%2Fmarketplace.visualstudio.com%2Fitems%3FitemName%3DSSIS.ssis-devops-tools%26amp%3Bssr%3Dfalse%23qna%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3Eextension%20Q%20%26amp%3B%20A%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EIf%20you%20receive%20the%20error%20%22The%20extension%20package%20size%20'26272573%20bytes'%20exceeds%20the%20maximum%20package%20size%20'26214400%20bytes'%22%20while%20trying%20to%20install%20this%20extension%20(starting%20with%20version%201.0.4.3)%20on%20Azure%20DevOps%20Server%20on%20premise%2C%20you%20need%20to%20run%20the%20following%20T-SQL%20command%20in%20the%20configuration%20database%20of%20your%20Azure%20DevOps%20Server%20instance%20(default%20DB%20name%3A%20Tfs_Configuration)%3A%20%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EEXEC%20dbo.prc_SetRegistryValue%20%40partitionId%20%3D%201%2C%20%40key%20%3D%20'%23%5CConfiguration%5CService%5CGallery%5CLargeExtensionUpload%5CMaxPackageSizeMB%5C'%2C%20%40value%20%3D%2050%2C%20%40identityName%20%3D%20null%20%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EAfter%20running%20this%20statement%20you%20need%20to%20restart%20the%20IIS%20service.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Version history
Last update:
‎May 08 2020 06:48 PM
Updated by: