data flow task

• Anoop Saxena

  Mr or Mrs. 500

  Points: 547

  More actions

  April 7, 2009 at 2:40 am

  #129152

  using SqlServer 2005/ XP

  I am using data flow task to import data from a file source into a table

  but I need to update existing row in table and Insert a new row if not exist.

  I am first time using data flow task please any body help me.

  Thanks

• Phil Parkin

  SSC Guru

  Points: 246993

  More actions

  April 7, 2009 at 2:46 am

  #973157

  This is not directly supported. I suggest that you bring the data in to a temporary (or staging) table (after having run TRUNCATE on it) and then use a stored proc to do the UPDATEs and INSERTs from this table to the main table.

  The absence of evidence is not evidence of absence.
  Martin Rees

  You can lead a horse to water, but a pencil must be lead.
  Stan Laurel

• Ramesh Saive

  SSC-Insane

  Points: 24275

  More actions

  April 7, 2009 at 5:36 am

  #973229

  See if these links help you..

  http://blogs.conchango.com/jamiethomson/archive/2006/09/12/SSIS_3A00_-Checking-if-a-row-exists-and-if-it-does_2C00_-has-it-changed.aspx

  http://www.sqlis.com/post/Get-all-from-Table-A-that-isnt-in-Table-B.aspx

  --Ramesh
  

  ---