Using bcp in Unix fails
Posted on 2004-10-27
I am trying to take out data from one table and put it into another table, the second table has a new column added with not null.
I use the following bcp command and when I try the"in " command it gives me an DB-LIBRARY error:
Unexpected EOF encountered in BCP data-file. error.
Here are comands I am using ,I would really appreciate youe quick help.
bcp oil_grain_ops.dbo.userlist out ogo.dat -Ssybcps2 -Usa -Ptest01 -c -t"|"
bcp oil_grain_ops.dbo.userlist_email in ogo.dat -Ssybcps2 -Usa -Ptest01 -c -t"|" -b5000
The bcp out says:
copied 43 rows,
The bcp in says:
copied 2 rows.
Thank you for your help in advance,