Home Forums SQL Server 2005 SQL Server 2005 Integration Services SSIS : Insert/update source to destination table RE: SSIS : Insert/update source to destination table

  • April 23, 2010 at 6:24 am

    #1156762

    I agree with ashokdasari, the MERGE is what I would do in this particular situation. I actually use the MERGE to handle TYPE II SCD in my data warehouse scenario. Very quick and powerful.