Post reply

Data Conversion in ssis

  • November 17, 2015 at 12:10 am

    #309692

    Hi ,

    I am using flat file as source.I have quantity column in flat file which is a Numeric datatype and target table quantity datatype is Numeric.

    I am able to load data from source to target but when I am comparing data from source to target I am not getting exact record from source flat files

    Source having data like

    Source >> Target

    31.61 >> 31.0000000000

    00029.430 >> 29.0000000000

    as we can see that data are not matching with source

    I can not change the target table quantity data type, is there any thing which I can do with source column data type.

    Thanks in advance 🙂

  • November 17, 2015 at 12:17 am

    #1840204

    Data in flat files does not have a data type.

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • November 17, 2015 at 12:26 am

    #1840205

    It is having Numeric data type

  • November 17, 2015 at 12:31 am

    #1840207

    By changing the scale value of column data coming correctly

    Thanks

  • November 17, 2015 at 12:36 am

    #1840209

    vipin_jha123 (11/17/2015)

    It is having Numeric data type

    Only because that is what is assigned to it by SSIS. You can change this.

    But I say again: flat file columns have no (explicit) data type.

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

Viewing 5 posts - 1 through 4 (of 4 total)

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