cancel
Showing results for 
Search instead for 
Did you mean: 

SQL Server Bulk Load snap throwing error like string data truncation

kkishore
New Contributor III

Hi Team,

we designed pipeline to read data from excel sheet using excel parser then loading same data into sql server table using SQL Server Bulk load snap but it is throwing below error.
There is no wrong data in the column showing the error.
Reason: #@ Row 1, Column 54: String data, right truncation @#

the data at Column 54 is like “Have/E22”

2 REPLIES 2

pmancevski
New Contributor III

Hi @kkishore

This error could possible occur because of the length of the table column.

Thanks,
Pero M.

kkishore
New Contributor III

@pmancevski ,

we have created field with data type is varchar(8000,NULL), provided enough length to store the data