Skip to main content
Get all from Table A that isn't in Table B
Entry Date: Rate:
Site:
Keywords:
RSS Description:
A common requirement when building a data warehouse is to be able to get all rows from a staging table where the business key is not in the dimension table. For example, I may want to get all rows from my STG_DATE table where the DateID is not in DIM_DATE.DateID. There are 2 ways to do this in conventional SQL. And using SSIS...
Comments:

Inserting bulk data into a table it's easy, but... having two tables that need to be synchronized is that an straight forward task

This article explains how to copy all the rows from an origin table to a destination one, taking into consideration that somes rows doesn't exists (insert / create) and some other yes (update)

you will find two SQL script solutions and two based on SSIS