Excel file (percent data type) to SQL table (vafrchar16) error

SQLServerCentral » Latest topics

Excel file (percent data type) to SQL table (vafrchar16) error

Tried to load excel file to sql table

dataflow task is failing because of data truncation error, in my source excel file it is % data type actual values are "2.35%"

in my sql table it is varchar(16) but it is failing with eerrror "Data trun

more info...