I'd like to do the following thing with a data flow task
- Get all the records from a source (for example customers from a textfile, flat file source)
- Then check for each record if the customer already exists in a table, for example with a customerID. If not, insert the record in the table (ole db destination), else copy the customer thats already in the table to another table (history table) and update the record with the customer from the textfile.
Is this possible , and what kind of data flow transformation do I need

insert or update data records
Daniel_MooSoft