Data Comparison Question

I am not sure if this is the correct forum for my question but I will give it a shot. I want to be able to create a dataset from an ODBC datasource and compare it to existing data in my SQL DB. If there are changes (inserts/updates/deletes) I want to raise seperate events for each row state. Is this possible to do with SSIS/DTS or am I on the wrong track with what I am trying to do?

Have a look at this and see if its any help: http://www.sqlis.com/default.aspx?311

-Jamie

|||Thanks for the link it looks like really good information. Do you think that this will work for all three row states (new/updated/deleted)?|||anybody?|||

These methods tells you whether an incoing row is there or not. i.e. Is it an insert or an update.

It does NOT tell you if a row has been deleted from source. For this you will have to do...well... the opposite.

-Jamie

|||Thank you very much you have been excellent help I was able to do exactly what I needed. For updates should it work the same or do I have to run a check on a particular column(s) and see if they match?|||

The article I linked to should have all the answers. You should use method 2 in there by the way.

-Jamie

|||ok thanks again