SSIS DevOps Tools new version tasks in preview

Published Apr 21 2021 11:31 PM 1,410 Views
Microsoft

SSIS DevOps Tools released new version of SSIS Build task and SSIS Deploy task. Major enhancements include:

  • SSIS Build task version 1.* (Preview)
    • Remove the dependency on Visual Studio and SSIS designer. Build task can run on Microsoft-hosted agent or self-hosted agent with Windows OS and .NET framework 4.6.2 or higher.
    • No need of installing out-of-box components.
    • Support protection level EncryptionWithPassword and EncryptionAllWithPassword.
  • SSIS Deploy task version 1.* (Preview)
    • Support protection level EncryptionWithPassword and EncryptionAllWithPassword.

Use new version of SSIS Build task:

  1. Microsoft-hosted agent or self-hosted agent with Windows OS and .NET framework 4.6.2 or higher.
  2. Add SSIS Build task and select Task version as 1.* (Preview). Default version is 0.*. 
  3. 1.* only properties:
    • Project Password
      Password of the SSIS project and its packages. This argument is only valid when the protection level of the SSIS project and packages is EncryptSensitiveWithPassword or EncryptAllWithPassword. For package deployment model, all packages must share the same password specified by this argument.

    • Strip Sensitive Data
      Convert the protection level of the SSIS project to DontSaveSensitve if this value is true. When protection level is EncryptSensitiveWithPassword or EncryptAllWithPassword, the argument Project Password must be correctly set. This option is only valid for project deployment model.

build-task-v1.png

Use new version of SSIS Deploy task:

  1. Add SSIS Deploy task and select Task version as 1.* (Preview). Default version is 0.*
  2. 1.* only properties:
    • Project Password
      Password to decrypt the ISPAC or DTSX files. This argument is only valid when the protection level is EncryptSensitiveWithPassword or EncryptAllWithPassword.

deploy-task-v1.png

 

Please refer to this page for more detail usage. If you have questions, visit Q&A.

 

%3CLINGO-SUB%20id%3D%22lingo-sub-2281198%22%20slang%3D%22en-US%22%3ESSIS%20DevOps%20Tools%20new%20version%20tasks%20in%20preview%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2281198%22%20slang%3D%22en-US%22%3E%3CP%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%3ESSIS%20DevOps%20Tools%3C%2FA%3E%26nbsp%3Breleased%20new%20version%20of%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fsql%2Fintegration-services%2Fdevops%2Fssis-devops-overview%3Fview%3Dsql-server-2017%23ssis-build-task-version-1-preview%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3ESSIS%20Build%20task%3C%2FA%3E%20and%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fsql%2Fintegration-services%2Fdevops%2Fssis-devops-overview%3Fview%3Dsql-server-2017%23ssis-deploy-task-version-1-preview%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3ESSIS%20Deploy%20task%3C%2FA%3E.%20Major%20enhancements%20include%3A%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3ESSIS%20Build%20task%20version%201.*%20(Preview)%3CUL%3E%0A%3CLI%3ERemove%20the%20dependency%20on%20Visual%20Studio%20and%20SSIS%20designer.%20Build%20task%20can%20run%20on%20Microsoft-hosted%20agent%20or%20self-hosted%20agent%20with%20Windows%20OS%20and%20.NET%20framework%204.6.2%20or%20higher.%3C%2FLI%3E%0A%3CLI%3ENo%20need%20of%20installing%20out-of-box%20components.%3C%2FLI%3E%0A%3CLI%3ESupport%20protection%20level%20EncryptionWithPassword%20and%20EncryptionAllWithPassword.%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3C%2FLI%3E%0A%3CLI%3ESSIS%20Deploy%20task%20version%201.*%20(Preview)%3CUL%3E%0A%3CLI%3ESupport%20protection%20level%20EncryptionWithPassword%20and%20EncryptionAllWithPassword.%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%3CSTRONG%3EUse%20new%20version%20of%20SSIS%20Build%20task%3A%3C%2FSTRONG%3E%3C%2FP%3E%0A%3COL%3E%0A%3CLI%3E%3CSPAN%3EMicrosoft-hosted%20agent%20or%20self-hosted%20agent%20with%20Windows%20OS%20and%20.NET%20framework%204.6.2%20or%20higher.%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%3EAdd%20SSIS%20Build%20task%20and%20select%20Task%20version%20as%201.*%20(Preview).%20Default%20version%20is%200.*.%26nbsp%3B%3C%2FLI%3E%0A%3CLI%3E1.*%20only%20properties%3A%3CUL%3E%0A%3CLI%3E%3CP%3E%3CFONT%20size%3D%223%22%3EProject%20Password%3C%2FFONT%3E%3CBR%20%2F%3E%3CFONT%20size%3D%223%22%3EPassword%20of%20the%20SSIS%20project%20and%20its%20packages.%20This%20argument%20is%20only%20valid%20when%20the%20protection%20level%20of%20the%20SSIS%20project%20and%20packages%20is%20EncryptSensitiveWithPassword%20or%20EncryptAllWithPassword.%20For%20package%20deployment%20model%2C%20all%20packages%20must%20share%20the%20same%20password%20specified%20by%20this%20argument.%3C%2FFONT%3E%3C%2FP%3E%0A%3C%2FLI%3E%0A%3CLI%3E%3CP%3E%3CFONT%20size%3D%223%22%3EStrip%20Sensitive%20Data%3C%2FFONT%3E%3CBR%20%2F%3E%3CFONT%20size%3D%223%22%3EConvert%20the%20protection%20level%20of%20the%20SSIS%20project%20to%20DontSaveSensitve%20if%20this%20value%20is%20true.%20When%20protection%20level%20is%20EncryptSensitiveWithPassword%20or%20EncryptAllWithPassword%2C%20the%20argument%20Project%20Password%20must%20be%20correctly%20set.%20This%20option%20is%20only%20valid%20for%20project%20deployment%20model.%3C%2FFONT%3E%3C%2FP%3E%0A%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3C%2FLI%3E%0A%3C%2FOL%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22build-task-v1.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F274616i7B7071C16BB4DE57%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22build-task-v1.png%22%20alt%3D%22build-task-v1.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3EUse%20new%20version%20of%20SSIS%20Deploy%20task%3A%3C%2FSTRONG%3E%3C%2FP%3E%0A%3COL%3E%0A%3CLI%3EAdd%20SSIS%20Deploy%20task%20and%20select%20Task%20version%20as%201.*%20(Preview).%20Default%20version%20is%200.*%3C%2FLI%3E%0A%3CLI%3E1.*%20only%20properties%3A%3CUL%3E%0A%3CLI%3E%3CP%3E%3CFONT%20size%3D%223%22%3EProject%20Password%3C%2FFONT%3E%3CBR%20%2F%3E%3CFONT%20size%3D%223%22%3EPassword%20to%20decrypt%20the%20ISPAC%20or%20DTSX%20files.%20This%20argument%20is%20only%20valid%20when%20the%20protection%20level%20is%20EncryptSensitiveWithPassword%20or%20EncryptAllWithPassword.%3C%2FFONT%3E%3C%2FP%3E%0A%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3C%2FLI%3E%0A%3C%2FOL%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22deploy-task-v1.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F274621iC160A3A68B75B22E%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22deploy-task-v1.png%22%20alt%3D%22deploy-task-v1.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPlease%20refer%20to%20this%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fsql%2Fintegration-services%2Fdevops%2Fssis-devops-overview%22%20target%3D%22_self%22%20rel%3D%22noreferrer%20noopener%22%3Epage%3C%2FA%3E%26nbsp%3Bfor%20more%20detail%20usage.%26nbsp%3BIf%20you%20have%20questions%2C%20visit%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fmarketplace.visualstudio.com%2Fitems%3FitemName%3DSSIS.ssis-devops-tools%26amp%3Bssr%3Dfalse%23qna%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%20data-linktype%3D%22external%22%3EQ%26amp%3BA%3C%2FA%3E.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-2281198%22%20slang%3D%22en-US%22%3E%3CP%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%3ESSIS%20DevOps%20Tools%3C%2FA%3E%26nbsp%3Bnew%20enhancements%3A%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3ESSIS%20Build%20task%20version%201.*%20(Preview)%3CUL%3E%0A%3CLI%3ERemove%20the%20dependency%20on%20Visual%20Studio%20and%20SSIS%20designer.%20Build%20task%20can%20run%20on%20Microsoft-hosted%20agent%20or%20self-hosted%20agent%20with%20Windows%20OS%20and%20.NET%20framework%204.6.2%20or%20higher.%3C%2FLI%3E%0A%3CLI%3ENo%20need%20of%20installing%20out-of-box%20components.%3C%2FLI%3E%0A%3CLI%3ESupport%20protection%20level%20EncryptionWithPassword%20and%20EncryptionAllWithPassword.%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3C%2FLI%3E%0A%3CLI%3ESSIS%20Deploy%20task%20version%201.*%20(Preview)%3CUL%3E%0A%3CLI%3ESupport%20protection%20level%20EncryptionWithPassword%20and%20EncryptionAllWithPassword.%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2281198%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Essis%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Co-Authors
Version history
Last update:
‎Apr 25 2021 07:53 PM
Updated by: