• As I said import everything into Staging table using Data Flow and then run MERGE by Execute SQL Task.

    Or if by ssis you mean specifically Data Flow then use OLE DB Command and Lookup components.


    Alex Suprun