Deploy SSIS packages in VSTS/TFS

If you need to deploy SSIS packages using VSTS/TFS, try using the following build task: https://marketplace.visualstudio.com/items?itemName=automagically.SSISDeployPackage

The task allows you to deploy ISPAC file to SSIS instance. When deploying you need to specify:

  • path to .ispac file to be deployed
  • name of the catalog folder where the package will be deployed
  • name of SSIS server where the package will be deployed
  • name of the SSIS project
  • name of the SSIS environment
  • project and package parameters to ignore during the deployment

Also, the task allows you to deploy SSIS package using a remote machine. To deploy SSIS package using remote machine, make sure Authentication required checkbox checked and specify:

  • name of the remote server to use to deploy SSIS package
  • remote user account
  • and remote user password
  • Oh yes, and you have an option to connect to remote machine using SSL, if you want

 

Have fun.