Post reply

Data Type conversion Problem

  • February 24, 2008 at 10:51 pm

    #127992

    Hi,

    I tried to convert excel data to flat file output using SSIS.one of the excel field contains the value 99.469 and i made the field datatype as DT_R8 format.But in the flat file output coming as 99.4689999999999.I don't understand why it is happening like that.Can someone help me to resolve this error?.I want the flat file file output also should be 99.469

    Regards

    Senthil

  • February 25, 2008 at 12:35 am

    #781480

    I don't know whether the below method satisfies your need...

    While transformation, convert the numeric column into varchar datatype and check the flat file.....

  • February 25, 2008 at 3:34 am

    #781493

    Thanks.I have converted the datatype values as string in Transformation expression and populated into flat file.It is working fine.

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

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