Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
taylan
Starting Member
5 Posts |
 Posted - 2014-05-06 : 05:50:24
|
Hi @ ALLbefore i explain my problem, below situation at the momenti 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, toomaybe 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 2008thanks for any help |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2014-05-09 : 06:00:50
|
| what you can do is to add a multicast in not existing path which can create copies of the input path. Take two outputs connect one to your existing insert step and join next copy to your required update step (you may use OLEDB command for that)------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
|
|
|
SSIS (insert and update at the same time)