• twin.devil (8/7/2014)


    ...

    Create a Derive Column data flow, place all the logic in the expression by doing so you will get the updated column you wanted, just use that column in the oledb command.

    Simple, readable and scalable.

    Did I just read scalable and OLE DB command in the same paragraph? 😉

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