So method used in this post can be used to find INSERTED / UPDATED / DELETED records from the source table and apply those changes into the destination table.In this example I used Merge Join Transformation, Conditional Split, and OLE DB Command transform to implement the solution.
This will completely recreate the metadata for the source. When I read your recommandation for refreshing the metadata of the data source, I get the feeling that in the case of an OLE DB Source, you select the table from the dropdown box. However, this will not prevent SSIS to screw up the metadata.When working with SSIS and source or destination metadata changes SSIS does not reset the metadata it deletes the changed column and adds a new one at the end of the list.This results in messy packages after several changes have occured. Actually, selecting a table from the dropdown is even worse than select *.To configure the OLD DB Command, Double click on the item: a.Select the relevant connection manager (it is the DB one you created earlier) b.