Tune Up Your PC » Post Topic » Assigning MSBuild Properties to SQLCMD Variables

Mon, 22 Jun 2009 05:54:52 GMT

re: Assigning MSBuild Properties to SQLCMD Variables

Brandon — Fri, 27 Nov 2009 15:52:12 GMT

I am getting the error:

the element itemgroup in namespace has invalid child element sqlcommand variable override

and the variable is not being passed.

This is what I have.

</ItemGroup>

There is a blue squiggly under SqlCommandVariableOverride

gertd — Fri, 27 Nov 2009 19:23:54 GMT

Q: I am getting the error: the element itemgroup in namespace has invalid child element sqlcommand variable override

A: The red squiggly is expect, since the schema for the XLM (http://schemas.microsoft.com/developer/msbuild/2003) does not include the definitions, which is not a problem

You will see multiple warnings when opening the XML of the project file in the error list like this:

The element 'ItemGroup' in namespace 'http://schemas.microsoft.com/developer/msbuild/2003' has invalid child element 'SqlCommandVariableOverride' in namespace 'http://schemas.microsoft.com/developer/msbuild/2003'. List of possible elements expected: 'Item' in namespace 'http://schemas.microsoft.com/developer/msbuild/2003'.

Q: variable is not being passed

A: Did you define the BuildNumber property?

I created a sample project, available at:

which outputs:

Creating SqlCmdMSBuild...

SQLCMD ProjectDirectory = d:\demo\SqlCmdMSBuild

SQLCMD AssemblyVersionNumber = 1.0.0.0

But you have to define the property BuildNumber like this:

</PropertyGroup>