Using the SSISMSBUILD extention

Apr 11, 2013 at 3:38 PM
Edited Apr 11, 2013 at 6:22 PM
I'm trying to setup a build server on my local machine using the TFS Build in visual studio 2010. The build will be using a XAML file (company standard).

I'm at the point where I can build a normal c# project and have my build controller, agent and definition setup correctly.

When I try to build a SSIS solution, I get the following error.
C:\Builds\10\Something.dtproj.metaproj: The project file "Something.dtproj" is not supported by MSBuild and cannot be built.

It seems that the SSISMSBUILD project in the code can resolve my issue. I'm not sure how to include it in MSBUILD and SSIS solution.


I can build the dlls with the Microsoft.SqlServer.IntegrationServices.Build.csproj file. How do I include it in MSBUILD and/or SSIS solution?

Any suggestions or advice would be appreciated.
May 10, 2013 at 5:28 PM
Edited May 10, 2013 at 5:29 PM
I've found my own solution and decided to share.

http://social.msdn.microsoft.com/Forums/en-US/tfsbuild/thread/37398f4f-530e-4561-8d1b-79cd303fdbd2/

DS19 provides a solution that works well for me

~~~~~~~
So I renounced to build it with devenv.exe command and now I'm investigating the MSBuild path: the tasks are from http://sqlsrvintegrationsrv.codeplex.com/ (main/SSISMSBuild), the build script is from http://pastebin.com/kbj8tRUz and the build command looks like below:


MSBuild SSISMSBuildDemo.msbuild /t:SSISBuild,SSISDeploy /p:SSISProj="fooProj",Configuration="Development",ProtectionLevel="EncryptSensitiveWithPassword", ProjectPassword="fooPass",SSISServer="fooServer",ProjectName="fooProjFolder"
~~~~
~~~