Forum Discussion

kkishore's avatar
kkishore
New Contributor III
3 years ago

SQL Server Bulk Load snap throwing error like string data truncation

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

  • pmancevski's avatar
    pmancevski
    New Contributor III
    3 years ago

    Hi @kkishore

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

    Thanks,
    Pero M.

    • kkishore's avatar
      kkishore
      New Contributor III
      3 years ago

      @pmancevski ,

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