Convert Varchar to Numeric Using SSIS 2005

• sqlstud

  SSCrazy

  Points: 2527

  More actions

  January 17, 2013 at 10:31 pm

  #269548

  Hi,

  Loading the data from Excel source to Sql Table using SSIS 2005.

  Have two columns Sample1 and Sample2 and both are declared as numeric in Sql Table.

  But while loading, it displayed the below error:

  There was an error with output column "Sample1" (678) on output "OLE DB Source Output" (11). The column status returned was: "The value could not be converted because of a potential loss of data.".

  When looking into the advanced Editor, both external and output columns shows datatype as "String".

  Please suggest how to solve this or how to convert Varchar to Numeric using SSIS 2005?

  Regards

  SqlStud

• Phil Parkin

  SSC Guru

  Points: 247172

  More actions

  January 18, 2013 at 3:16 am

  #1578612

  Have you tried using a data conversion component?

  ---