Post reply

Update a column using Lookup Transformation

  • June 25, 2009 at 9:40 am

    #139203

    Hi All,

    My aim is to assign Ids to a table based on the values in lookup table. I am using lookup transformation for this. I am not able to update the column rather i have to create a complete new table and I want to avoid this. Is there any chance of updating the field using lookup transformation? I am using lookup transformation to get the no match and the error rows separately. I want the field to be updated in the same table. Can anyone help me on this please?

    Thanks in advance:-)

    Ashu

  • July 1, 2009 at 7:13 pm

    #1018843

    You cannot do it with the Lookup, you CAN do it by utilizing the OLEDB destination with the destination being set by a query, where you can execute an update for each row in the dataflow, your trick is to only allow rows into that destination that you want updated..

    Clear?

    CEWII

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

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