Introduction

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

Quick links

• Task Requirements
• How to setup Build Task
• How to setup Deploy Task
• Latest Updates

Tasks Description

Build Task

Build Visual Studio project, containing packages and parameters. It is built to a project deployment package (.ispac) https://msdn.microsoft.com/en-us/library/hh213290.aspx

Deploy Task

Deploy .ispac package to SSIS instance using windows Authentication (SQL auth is not possible by MSSQL security architecture)

Task Requirements

Build Task

SQL Server Data tools must be installed on the Agent Server (Build Server) Download: https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt

SSDT for VS2017 can be installed on the Agent Server (Build Server) in New Instance or as part of Visual Studio. Please select the correct Instance Option

Deploy Task

SQL Shared Management Objects must be installed on the Agent Server (Release Server) https://docs.microsoft.com/en-us/sql/relational-databases/server-management-objects-smo/installing-smo

Please make sure Agent Service account have appropriate permission on the target SQL Server

How to setup Build Task

How to setup Deploy Task

Project Parameters

Parameter must be set in Project. Task will replace values only. Inline or File options.

Inline JSON Example:

{
   "parameters":[
      {
	     "Name":  "TestParameter1",
	     "Value": "TestParameterValue1"
      },
      {
	     "Name":  "TestParameter2",
	     "Value": "TestParameterValue2"
      }
   ]
}

Devenv Instance Options

See Build Task Requirements

Contribution

File an issue for bug fixes and features and discuss existing proposals

Latest Updates

1.x

Supported version TFS 2017, 2018, VSTS - Hosted, Hosted VS2017

Implemented option for Custom path to Devenv

0.x

Supported version TFS 2013, 2015, 2017, VSTS Hosted Agent