none
BCP Error : SQLState = 37000, NativeError = 102

    Question

  • I have this error when I input data with BCP :

    SQLState = 37000, NativeError = 102

    The thing is that I extracted the file from the exacte same table.

    Cmd Out :

    bcp.exe database..Table out File.txt -Udbo -Ppassword -Sserver -t";" -c

    Cmd In:

    bcp.exe database..Table in File.txt -Udbo -Ppassword -Sserver -t";" -c

    Any thought?

    Monday, November 14, 2011 5:18 PM

Answers

  • Found the problem. I had one column name with a space in the name : (User Name)

    Doesn't work with the bcp so it seems.

    • Marked as answer by JArchambault Monday, November 14, 2011 5:24 PM
    Monday, November 14, 2011 5:24 PM