Why is the SqlCmd MSBuild task throwing an error when run with the TFS build command?

I asked about this on the MSBuild extension site , but I figured I would try to get some more eyes from it, in case someone else had a similar experience:

I have a fairly simple task that needs to execute a series of sql script files in a folder. (The task is located in the OperationalDB.msbuild file). The task looks like this:

<MSBuild.ExtensionPack.SqlServer.SqlCmd
    TaskAction="Execute"
    Server="$(SqlServerName)"
    Database="$(SqlCatalogName)"
    InputFiles="@(OperationalStaticDataFiles)"
/>

      

It doesn't work when run as part of a TFS 2008 Build. The log error says:

C: \ b \ 56 \ S \ Main \ Builds \ OperationalDB.msbuild: warning: Exit Code 1. Failure: Sqlcmd: Error: Internal error in ReadTextLine (Reason: Unspecified error).

Worse (from a debugging point of view) if I log into my build server with the same account as the command build service and run OperationalDB.msbuild via MSBuild from the command line, it works fine. No errors, everything SQL does.

My understanding of the task is that it terminates the SQLCmd console application. So I tried to run this on the build server. He also worked. The variable in the mix seems to be TFS Team Build. But that doesn't give me a clue as to how to investigate it - just the error mentioned above.

Any ideas?

+2
msbuild tfs2008


source to share


No one has answered this question yet

Check out similar questions:

139
Assembly build error: path ... already mapped to stage
five
How to solve the problem "Only one project can be specified" from the <msbuild> task in CruiseControl.NET
3
Is there any msbuild task to get free block space in TFS Builds (TFS2008)?
1
VS2010 with MSTests unit tests and TFS2008 and MsBuild - unit test won't start
1
BizTalk Deployment Platform throws MSBuild errors MSB4061
1
How do I get the build crash when bcp starts from a msbuild script?
0
Build team summary with errors / warning from ant build
0
Deploy using the build command and psexec & # 8594; integration test tests
0
How to get SQL query with changes using DB Pro for .net and SQl Server when using Team Team?
0
Error while executing unit tests from MSBuild



All Articles
Loading...
X
Show
Funny
Dev
Pics