Joining tables which doesnt have primary keys using ssis RRS feed

  • Question

  • Hello all,

    my requirement is i have to load data by comparing the previous month data with the current data and do calculations for columns in ssis 

    i dont have any primary keys in table. the table has just date column, agentno(repeats multiple times), insuranceno, monthly amount, up to date amount.

    if package runs using previous month it loads the data and if package runs again next month, up to date column values should be from previous month and current month ( summation).

    im not sure how to do that using ssis where primay keys not exists. how should i insert previous month in to column and so calculations. 

    please help me out guys

    Monday, August 31, 2015 11:17 PM