Update of two tables at the same time

• haydaaa

  SSC Enthusiast

  Points: 132

  More actions

  May 6, 2014 at 4:02 am

  #307460

  Hi @ ALL

  before i explain my problem, below situation at the moment

  i have a simple data flow task, with a OLE Source, Search and a target OLE.

  I´m just checking the values in the target, by not existing a new row is getting inserted.

  What i want to have is:

  by not existing i want to make additionally an update in another table (in the same DB) at the same time, too

  maybe two red arrows could make it happen but i know i don`t have these chance

  maybe with variables (but variables are too complicated for me)

  maybe with event handlers?? (i don`t know)

  ..........

  Is there any chance to realize that with SQL SERVER 2008

  thanks for any help

• Umer Akram

  SSC-Insane

  Points: 22209

  More actions

  May 6, 2014 at 4:21 am

  #1710990

  There are two ways to achieve for update

  1. Use this Updating Rows in Incremental Loads – Level 4 of the Stairway to Integration Services[/url] which is a slower way because its a row by row execution.

  2. you can insert/dump the matching row in a staging table and then use a ExecuteSQL task and place a update query in it. Its a set based approach.

  Hope it helps.

• Phil Parkin

  SSC Guru

  Points: 247158

  More actions

  May 6, 2014 at 4:26 am

  #1710991

  twin.devil (5/6/2014)

  ---

  There are two ways to achieve for update

  1. Use this Updating Rows in Incremental Loads – Level 4 of the Stairway to Integration Services[/url] which is a slower way because its a row by row execution.

  2. you can insert/dump the matching row in a staging table and then use a SQL Script task and place a update query in it. Its a set based approach.

  Hope it helps.

  Item 2 is the way to go, except I'd use an ExecuteSQL task. There's no need to add a Script Task just to run an UPDATE query.

  ---

• Umer Akram

  SSC-Insane

  Points: 22209

  More actions

  May 6, 2014 at 4:32 am

  #1710992

  My mistake , i wanted to write "ExecuteSQL task" :-)...

  Thanks Phil ...

  i will update my response

• haydaaa

  SSC Enthusiast

  Points: 132

  More actions

  May 6, 2014 at 6:56 am

  #1711037

  thanks guys...

  i will try it...