Microsoft official tools for building & deploying SQL Server Integration Services (SSIS) projects.
This product enables users to build continuous integration & continuous delivery (CI/CD) solutions for SQL Server Integration Services (SSIS) projects in Azure DevOps. It contains three tasks:
SSIS Build Task: supports building single or multiple dtproj files in project deployment model or package deployment model.
SSIS Deploy Task: supports deploying single or multiple ispac files to on-premise SSIS catalog and Azure-SSIS IR, or SSISDeploymentManifest files and their associated files to on-premise 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 detailed usage and release notes.
What's new in version 1.* (preview)
SSIS Build Task
Remove the dependency on the installation of Visual Studio or SSIS runtime.
No need of installing any out-of-box components.
Support protection level EncryptSensitiveWithPassword and EncryptAllWithPassword.
Support both vs2017-win2016 and windows-2019 for Microsoft-hosted agents.
SSIS Deploy Task
Support protection level EncryptSensitiveWithPassword and EncryptAllWithPassword
Standalone SSIS DevOps Tools
Don't want to depend on Azure DevOps, Visual Studio and SSIS runtime? Please try out the new Standalone SSIS DevOps Tools! Feel free to ask a question in the Q&A page when you have any issues or feedbacks on it.