Merging tables

• Andrew H

  SSC Rookie

  Points: 29

  More actions

  January 3, 2008 at 6:20 am

  #182396

  Hi All,

  SSIS newbie here.

  I have two tables, one in oracle one in SQL server. I want to perform the equivalent of oracle or SQLServer 2008's merge statements.

  So compare Table A with Table B and update or insert according to whether the record from A exists or not in B.

  This seems a fairly basic thing, yet I can't find a transformation tool in SSIS that can do it. am I looking in the wrong place?

  Cheers,

  A.

• Norman Kelm

  SSCommitted

  Points: 1922

  More actions

  January 3, 2008 at 7:35 am

  #764359

  Hi Andrew,

  I've not done this myself, but I have seen some articles on using the Slowly Changing Dimension to to this type of thing. Many folks are complaining about performance though.

  There is also this: http://www.sqlbi.eu/Home/tabid/36/ctl/Details/mid/374/ItemID/0/Default.aspx a custom task to do a table difference.

  Norman

  DTS Package Search

  http://www.dtspackagesearch.com/

• Andrew H

  SSC Rookie

  Points: 29

  More actions

  January 3, 2008 at 8:46 am

  #764402

  Hi Norman,

  Thanks for your quick reply.

  I actually ended up finding this:

  http://www.sqlservercentral.com/articles/SQL+Server+2005+-+SSIS/anelegantetlsolutionexceptforlostdata/2182/[/url]

  which, I should have thought about to start with. (the article's about something different, but it uses a process that I does exactly what I need).

  A.