I have a little something that's driving me crazy. I have a pretty straightforward task that should execute a series of sql script files in a folder. (The task is in a file called OperationalDB.msbuild). The task looks like this:
It fails when running as part of a TFS team build. The log error says:
C:\b\56\S\Main\Builds\OperationalDB.msbuild : warning : Exit Code 1. Failure: Sqlcmd: Error: Internal error at ReadTextLine (Reason: Unspecified error).
Worse, (from a debugging perspective), if I log in to my build server with the same account that the build service is running, and run OperationalDB.msbuild through MSBuild from a command line, it works beautifully. No errors, all the SQL executes.