Data Conversion in ssis

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • vineetbindal
    New Member
    • Jan 2009
    • 57

    Data Conversion in ssis

    Hi All,

    We hava a coloumn with float values and we are writing it in a text file. the data type in ssis is DT_R8.

    and DataScale is 2.

    that means if we are sending a value like 34.40 it should write the same value in destination file.


    but what it does is 34.399999999999 9999 i am confused why is i doing that?

    can some one please tell me a solution to it.
    Last edited by Frinavale; Feb 12 '09, 07:48 PM. Reason: Moved to SQL Server Answers from Insights
  • ck9663
    Recognized Expert Specialist
    • Jun 2007
    • 2878

    #2
    Try converting it to float

    -- CK

    Comment

    Working...