You are going to need a dataflow task.
Inside this you are going to need a flatfile source, then a data lookup. configure the lookup to re-direct not found rows and found rows. Insert into the database using SQL destination and multicast that to your audit / analytics table.
OR
create a flatfile source, read the data and insert into your database into a staging table. Then using the SQLCommand task. Set this task to use a stored procedure that has your business logic for analysing the inserts and updates.
http://oakdome.com/programming/SSIS_Lookup.php[
^]