• If that's the case, there are a few troubleshooting steps I'd recommend:

    First, add a Data Viewer to each data pipeline in your data flow. This will allow you see the data as it passes from one component to the next, and you'll be able to tell if the rounding is taking place in the package itself, and if so, exactly where it happens.

    If that doesn't reveal anything, look at the advanced properties of the destination component (right click and select "show advanced settings"). Make sure that the column metadata is correct, and not using a whole number type such as DT_I8.

    Finally, if all else fails, delete and recreate the destination component to see if this resolves the issue.

    Hope this helps...

    Tim Mitchell, Microsoft Data Platform MVP
    Data Warehouse and ETL Consultant
    TimMitchell.net | @Tim_Mitchell | Tyleris.com
    ETL Best Practices