BCP CLI Cannot find Invalid object name. [modified]
-
I'm trying to export the results of a stored procedure to a csv, here's what I've got: "C:\Program Files\Microsoft SQL Server\90\Tools\Binn\bcp.exe" myDb.dbo.spExport out "Data.csv" -T -Slocalhost -t";" -c It keeps telling me "Invalid object name 'myDb.dbo.spExport'." Other stored procedures don't work either and none require parameters. Pointing to a table works so I thought I was pointing to at the SP's the right way. What am I doing wrong? -Nevermind, got it working: "C:\Program Files\Microsoft SQL Server\90\Tools\Binn\bcp.exe" myDb.dbo.spExport queryout "Data.csv" -T -Slocalhost -t";" -c
modified on Tuesday, May 31, 2011 10:08 AM
-
I'm trying to export the results of a stored procedure to a csv, here's what I've got: "C:\Program Files\Microsoft SQL Server\90\Tools\Binn\bcp.exe" myDb.dbo.spExport out "Data.csv" -T -Slocalhost -t";" -c It keeps telling me "Invalid object name 'myDb.dbo.spExport'." Other stored procedures don't work either and none require parameters. Pointing to a table works so I thought I was pointing to at the SP's the right way. What am I doing wrong? -Nevermind, got it working: "C:\Program Files\Microsoft SQL Server\90\Tools\Binn\bcp.exe" myDb.dbo.spExport queryout "Data.csv" -T -Slocalhost -t";" -c
modified on Tuesday, May 31, 2011 10:08 AM
BCP is tricky at best.