Incremental loading data in SSIS

• vipin_jha123

  Hall of Fame

  Points: 3085

  More actions

  August 30, 2015 at 2:08 am

  #311259

  Hi I am looking to load data incrementally from staging to spectrum database.

  Master = Staging table

  Detail = Spectrum table

  On below logic

  · If record from Detail (Spectrum table) is null

  then do insert the record into Spectrum table

  set status_flag to 'A' for active

  else do update the record (replace all old values with new values)

  set status_flag to 'A' for active

  end-if

  · If record from Master (Staging table) is null

  then do soft delete

  set status_flag to 'D' for delete

  end-if

  Could any one help me how the ssis package help me to achieve the above scenario.

• michal.lisinski

  SSCertifiable

  Points: 7201

  More actions

  August 31, 2015 at 5:48 am

  #1823333

  Hi

  Here is very good example of incremental load http://sqlblog.com/blogs/andy_leonard/archive/2007/07/09/ssis-design-pattern-incremental-loads.aspx

  As the last step add Execute T-SQL Statement Task to update status_flag = 'D' for rows which are not exist in Staging table.

  Best regards

  Mike