Post reply

SSIS update after llookup not working

  • June 5, 2019 at 3:43 pm

    #3650481

    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 = ?

  • June 5, 2019 at 4:40 pm

    #3650507

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

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

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

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