question

DataMavn82 avatar image
DataMavn82 asked

invalid buffer size for BCP column property

Created a format file:bcp DBNAME.test format NUL -c -t "" -T -f test.fmt (fixed-width file) Table and file Definition: Length 5 21 10 1 8 15 10 10 3 8 20 30 30 20 2 30 4 23 10 40 100 1 Format File Definition (attached) BCP Code: bcp DB_NAME.test in test.txt -T -f test.fmt I checked the file for hidden characters, spaces, etc. [1]: /storage/temp/1548-test.txt
sqlsql serverimport-databcpcommand-line
test.txt (2.8 KiB)
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Kev Riley avatar image Kev Riley ♦♦ commented ·
You've attached the format file, but no data file?
1 Like 1 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.