I am importing a text file daily through SSIS, inside the text there are productID, qty, selling price...etc. I need to check the productID against the table that will import the file to see if the same productID's was exist in the previous day. If yes the table column pending_day for the new import will increase 1, if not then the pending_day is 0.
I was thinking to use a derived column to accomplish this but can not figure how to do it. Can you advice what transform component should I use for this purpose? Thanks