CODEWITHSUNDEEP
sqlpowershellbulkinsert
CRa
CRa

Reputation: 31

SQL Bulk load data conversion error (truncation) (Restatement_Reason)

Hi all I have been getting the following error when trying to bulk load data into SQL with powershell:

Bulk load data conversion error (truncation) for row 13651, column 201 (Restatement_Reason).

Do you have any idea what this could mean??

If you need more info I can post code/data.

Thanks in advance!

Upvotes: 0

Views: 673

Answers (1)

Jower
Jower

Reputation: 575

Check the data you are trying to bulk insert. More specific, check row 13651 and column 201.

It propably means that the data in that location is too wide for the column you are trying to insert it into.

Upvotes: 1

Related Questions