May 6, 2014 at 4:02 am
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
May 6, 2014 at 4:21 am
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.
May 6, 2014 at 4:26 am
twin.devil (5/6/2014)
There are two ways to achieve for update1. 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.
May 6, 2014 at 4:32 am
My mistake , i wanted to write "ExecuteSQL task" :-)...
Thanks Phil ...
i will update my response
May 6, 2014 at 6:56 am
thanks guys...
i will try it...
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply