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 |
|
SQL_Rookie
Starting Member
32 Posts |
 Posted - 2008-02-28 : 16:44:04
|
| Can you have more then one OLD DB desination connected to the slowly changing task for the NEW OUTPUT scenario. I know I can have more then one if they have different outputs...like New Output for one and the other have fixed attrib output or unchanged output.I have a query that gets data but I want to insert that data in 2 different tables at the same time. I can not re-query to get the data since it may change the data I get the second time I query. So if I have a query that returns a data set how can I insert into 2 diff tables? |
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2008-02-28 : 16:51:05
|
| yes - use MultiCast...See my post (just below yours - http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=98144 ), I tried to "diagram" my design, and you'll see it does what you want, I think*##* *##* *##* *##* Chaos, Disorder and Panic ... my work is done here! |
 |
|
|
|
|
|
Multiple OLD DB destinations