Skip to content
| Marketplace
Sign in
Azure DevOps>Azure Pipelines>SSIS Build & Deploy
SSIS Build & Deploy

SSIS Build & Deploy

ToxicGlobe

|
6,080 installs
| (29) | Free
Added support for Hosted VS2017 pool and introduced many new functionalities.
Get it free

Build Status

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

image

How to setup Deploy Task

image

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

SSDT Version / VS Version
VS2013 All Versions
VS2015 All Versions
VS2017 Enterprise
VS2017 Professional
VS2017 Community
VS2017 New Instance
Hosted VS2017
Custom

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

  • Contact us
  • Jobs
  • Privacy
  • Manage cookies
  • Terms of use
  • Trademarks
© 2025 Microsoft