SQL Server Bulk Load snap throwing error like string data truncation

Designing Pipelines
#1

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

Hi @kkishore

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

Thanks,
Pero M.

#3

@pmancevski ,

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