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 Build with devenv (Visual Studio) extension by Mario Majcica.