SSIS update after llookup not working

  • dallas13

    SSCertifiable

    Points: 7491

    I am importing data from db2-dev server to stg table in SQL in 1st data flow task and bringing only few columns. -- This is done and works.

    I need to bring remaining columns from deb-prod to this same stg table in SQL using another data flow task. Here I have db2 source and then lookup that compares db2 source with stg in SQL and then updates remaining columns.

    But i only updates 1st column instead of all. Can u tell why? See below update statement.

    The primary key in both DB2 dev and prod server table is same = ( Account _NO + Bill_Cycle_Date)

    UPDATE STG_BillComparison_Analytics

    SET

    TOTAL_BILL_AMT_PROD = ?

    ,LPC_AMT_PROD = ?

    WHERE ACCOUNT_NO = ?

    AND BILL_CYCLE_DATE = ?

  • Phil Parkin

    SSC Guru

    Points: 243862

    Please do not cross-post. Answers here, please.

    If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.

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

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