Find match record on the basis of primary key and then find out change record RRS feed

  • Question

  • Hi,

    I am new to ssis package need help to achive below task.

    I have flat file which I am loading in table. My flat file may contain records that is already present in table. I want to find out records from the flat file which are already available in table. After finding out records, I want to check which columns value got changes and base on the result I want to update status column saying record got change.

    Please help me with step by step explanation.

    Ex of table

    GUID   col1  Col2 Col3 Col4 Status

    (Col1,Col2) Primary key.


    Wednesday, February 26, 2014 6:25 PM


All replies