MSSQLTips

hi,

while importing data from excel to sql table in DTS i am getting the following error.

general conversion error on column pair(source column(DBTYPE_WSTR),destination column(DBTYPE_NUMERIC))

sample (excel) input cap 24% to the table data type decimal

thanks in advance

Looks like your data types are mismatched. 

To fix this you can either modify the SQL table to accept string data instead of just numeric data or you could convert the Excel data to numeric prior to loading into your SQL table and throw out any non numeric values.