SSIS DevOps Tools Azure DevOps extension was released a while ago. While for customers who use other CICD platforms, there was no straight-forward integration point for SSIS CICD process.
Standalone SSIS DevOps Tools provide a set of executables to do SSIS CICD tasks. Without the dependency on the installation of Visual Studio or SSIS runtime, these executables can be easily integrated with any CICD platform. The executables provided are:
Installation
.NET framework 4.6.2 or higher is required.
Download the latest installer from download center, then install.
SSISBuild.exe examples
SSISBuild.exe -p:"C:\projects\demo\demo.dtproj"
SSISBuild.exe -p:C:\projects\demo\demo.dtproj -c:DevConfiguration -pp:encryptionpassword -o:D:\folder
SSISBuild.exe -p:C:\projects\demo\demo.dtproj -c:DevConfiguration -pp:encryptionpassword -ss -l:diag
SSISBuild.exe examples
SSISDeploy.exe -s:D:\myfolder\demo.ispac -d:catalog;/SSISDB/destfolder;myssisserver -at:win
SSISDeploy.exe -s:D:\myfolder\test.ispac -d:catalog;/SSISDB/folder/testproj;myssisserver -at:sql -u:sqlusername -p:sqlpassword -pp:encryptionpassword
SSISDeploy.exe -s:D:\myfolder\mypackage.SSISDeploymentManifest -d:file;\\myssisshare.file.core.windows.net\destfolder -u:Azure\myssisshare -p:storagekey
SSISDeploy.exe -s:D:\myfolder -d:file;\\myssisshare\destfolder
Please refer to this page for more detail usage. If you have questions, visit Q&A or ssistoolsfeedbacks@microsoft.com.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.