Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

MSBuild DeploymentModel unrecognised error in deploying SSIS package

I created a PowerShell script to automate deployment for SSIS projects and used it in a custom TFS task. Within this task I used a msbuild step to build the SSIS project which keeps failing with this error:

Error MSB4067: The element DeploymentModel beneath element Project is unrecognized.

I built the SSIS projects in visual studio 2015 just fine. I have tried msbuild version 12.0 and 15.0 and they both have the same error. Thank you

like image 405
user7400346 Avatar asked Sep 15 '17 13:09

user7400346


1 Answers

When you build your SSIS projects via VS, actually is calling /Build (devenv.exe), not directly using MSBuild.

There is no build-in task that supports building via devenv.exe.Still in the backlog. More details please refer: "Visual Studio Build" build step that actually invokes devenv.com instead of msbuild?

As a workaround, you could try to use 3-party extension task SSIS Build & Deploy for now.

like image 114
PatrickLu-MSFT Avatar answered Oct 13 '22 01:10

PatrickLu-MSFT