Modifying a project to only insert new records

• Isabelle2378

  SSCertifiable

  Points: 6174

  More actions

  July 3, 2007 at 5:04 pm

  #153660

  Hi,

  I have a package that I created that pulls data from an Oracle database, does some transformations and inserts the data into a SQL Server table.  I need to modify my package to pull the data from the Oracle database and only insert the records into the SQL Server table if they do not exist.  If the location is already in the SQL Server table, do nothing.  I have been searching through my books and can't see an easy way to do this. Can anyone point me in the right direction?

  Thanks,

  Isabelle

  Thanks!
  Bea Isabelle

• Catherine Eibner

  Ten Centuries

  Points: 1344

  More actions

  July 3, 2007 at 9:23 pm

  #717046

  try this link:

  http://sqljunkies.com/WebLog/ashvinis/archive/2005/06/15/15829.aspx

  or try searching "UPSERT" or "SSIS Insert & Update" on Google

   

  ---

  Kindest Regards,

  Catherine Eibner
  cybner.com.au

• Jason Coleman

  SSCrazy

  Points: 2187

  More actions

  July 4, 2007 at 4:26 am

  #717109

  I have used the following when updating new records in our data warehouse (good tutorial)

  http://www.sqlis.com/311.aspx

  Works very well and does not load all the records into memory at runtime.