Bulk Data Load Conversion Error?

D

dotruger372019-10-18 17:50:51

SQL

dotruger37, 2019-10-18 17:50:51

Throws the error "Bulk data load conversion failed (type mismatch or invalid character for the specified code page) at line 1, column 5 (YearFoundation)"

Reply

Answer the question

In order to leave comments, you need to log in

2 answer(s)

K

Konstantin Tsvetkov, 2019-10-18
@dotruger37

ROWTERMINATOR = '0x0A'

D

d-stream, 2019-10-18
@d-stream

I think it's worth starting with select * from ... - in order to see what sql sees
(as a version - "dancing" with ROWTERMINATOR)