Build SSIS Projects

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:

To build your SSIS project, you need to invoke the devenv.com command-line. This is best done with the one of the many Azure Pipeline extensions such as Mario Majcica's Build with devenv (Visual Studio) extension.

If your build pipeline should fail randomly one day on the Build with devenv (Visual Studio) step, then check for the potential problems listed at the bottom of our Build Server Setup page.