Post reply

SSIS: How to prevent rounding off

  • October 10, 2012 at 9:49 pm

    #393357

    Hi all,

    I have created an SSIS package in which there is a task which we transfer data from oledb source to oledb destination.(2 different tables).

    The column 1 in source table is of type decimal(11,3). But when I run this task the corresponding column in destination table is getting rounded off. i.e. value 0.25 is stored as 0, 1.5 is stored as 1 etc.

    Please tell me to prevent rounding off here.

    Thanks in advance.

  • October 11, 2012 at 4:51 am

    #1548000

    Can you check the Input and Output Properties OLEDB Source and confirm the OLE DB Source Output->Output Columns, what data type is appearing into it? It shoulde be a DT_DECIMAL OR DT_NUMERIC with Precision as 11 and Scale as 3?

    Thanks,

    Vikash Kumar Singh || www.singhvikash.in

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

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