VSTS Extension task to build and deploy Visual Studio Project - SQL Server Integration Services using the Project Deployment Model.
A Visual Studio project, containing packages and parameters, is built to a project deployment file (.ispac). Deployment of Projects and Packages
Please check the Wiki https://github.com/ToxicGlobe/VSTS-SSIS-Extension/wiki
https://github.com/ToxicGlobe/VSTS-SSIS-Extension/wiki/How-to-Setup-build
- Contributions are welcome!
- Submit bugs and help us verify fixes
- Submit pull requests for bug fixes and features and discuss existing proposals
0.3.346
Implementation for the DeploySSISTask, enabling the task to be used in a deployment pipeline to deploy SSIS projects. Thanks to https://github.com/sschutten !!
It takes a few parameters:
- Project File Path: the location of the *.ispac file
- Project Name: the name of the SSIS project
- Server Name: the name/instance of the SSIS server
- SSIS Catalog
- SSIS Catalog Folder: the Folder is created if it doesn't exist
- Project Parameters: the task supports project parameter values, so you can specify different parameter values for each environment. Project parameters are provided each on a separate line in the form of [name]=[value].
Other small tweaks include:
- Remove space from task name as only alphanumeric characters are allowed
- Add DeploymentGroup to runsOn options
- Change Devenv.exe to Devenv.com for reliable build
- Removed "Preview" status
0.1.0
Supported version VS2013, VS2015
- Implement custom path for Devenv.com utility