Post reply

derived columns related with decimal

  • December 15, 2011 at 10:27 am

    #391139

    We have a table for a column called FTE, its data type is decimal (6,2). it stored values of 1.00, 0.33, 0.50.

    Now I have a flat file source which stores FTE as 1.000, 0.200,0.600,0.330, I need to use derived columns to convert it to what we have in the database table data type.

    What ssis package expression can I do?

    THanks

  • December 16, 2011 at 12:21 am

    #1422324

    sqlfriends (12/15/2011)

    We have a table for a column called FTE, its data type is decimal (6,2). it stored values of 1.00, 0.33, 0.50.

    Now I have a flat file source which stores FTE as 1.000, 0.200,0.600,0.330, I need to use derived columns to convert it to what we have in the database table data type.

    What ssis package expression can I do?

    THanks

    You can use the data conversion component. It's quite obvious from it's name what it is supposed to do.

    If you insist on using derived columns, you can use the following expression:

    (DT_NUMERIC, 6, 2) myColumn

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

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

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