Error messaging while using BCP in SQL Server 2005
I am getting this error while using the Bulk Copy Program (version 9.0) in SQL Server 2005:
"An error occured while processing the command line".
I am using the following command:
bcp MyDatabase..temptable in "C:Documents and SettingsRishiOut.txt" -c -r n -SMyServer -UHamp -Ppass123 >>Error.txt
Why might this be?
Software/Hardware used:
Software/Hardware used:
ASKED:
November 10, 2008 7:24 PM
UPDATED:
November 10, 2008 10:46 PM
Answer Wiki:
It could be any number of things. You could have an invalid -r value. You may not have permissions to the table.
Setup SQL Profiler and run it against the database while you run the command. Add in all the Error items and see if SQL Profiler gives you any information about the error from the SQL Engine. If it doesn't then it's strictly a switch problem on your bcp command it self.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
