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 i...
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