Building SSIS solution using visual studio online build definition... .dtproj is not supported by MSBuild and cannot be built

Question

I've created a build definition via visual studio online that builds an SSIS project (dtproj). The build appears to succeed but there is a warning that appears stating "dtproj is not supported by MSBuild and cannot be built".

SSDT has been installed on the build server.

Does anyone have any ideas why this warning would be showing up?

Answer 1

MSBuild cannot build the project file format that SSDT uses. It is a pre-msbuild visuals studio format.

There's a hacky way to create an msbuild project that performs the necessary tasks but the easiest way is not not use MSBuild for this project but build it via the visual studio command line devenv.exe /build. Since this builds from visual studio, it understands all project file formats and has the necessary SSDT plugins.