Skip to content

Latest commit

 

History

History
49 lines (39 loc) · 1.94 KB

README.md

File metadata and controls

49 lines (39 loc) · 1.94 KB
Raw

Build Status

Introduction

VSTS Extension task to build and deploy Visual Studio Project - SQL Server Integration Services using the Project Deployment Model.

Description

A Visual Studio project, containing packages and parameters, is built to a project deployment file (.ispac). Deployment of Projects and Packages

Documentation

Please check the Wiki https://github.com/ToxicGlobe/VSTS-SSIS-Extension/wiki

How to Setup build

https://github.com/ToxicGlobe/VSTS-SSIS-Extension/wiki/How-to-Setup-build

Contribute

  • Contributions are welcome!
  • Submit bugs and help us verify fixes
  • Submit pull requests for bug fixes and features and discuss existing proposals

file an issue

Latest Updates

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

TODO:

  • Implement custom path for Devenv.com utility