Post reply

Convert Varchar to Numeric Using SSIS 2005

  • 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

  • January 18, 2013 at 3:16 am

    #1578612

    Have you tried using a data conversion component?

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply