Skip to content

Build SSIS Projects

Jump to bottom
Dr John Tunnicliffe edited this page May 11, 2019 · 4 revisions

Unfortunately, SSIS projects can only be built using Visual Studio itself. Although there are a wide variety of command line switches for devenv.com, there are also numerous problems.

Firstly, if you use Microsoft's Azure Pipeline extension, it simply does not work as under the hood it uses MsBuild which cannot cope with SSIS projects. So avoid using this component: Don't use this!

DevOps your Data Warehouse

Import into SSDT

Build

Deployment

Unit Tests

Integration Tests

Packaging Artifacts

Deployment Tools

Clone this wiki locally