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 |
|
mobasha
Starting Member
45 Posts |
 Posted - 2007-05-14 : 03:43:56
|
| Hi every one I know that my questions is being weird but this things I really need to know any way am new for using DTS packages and I need to know is there a way to call a stored procedure which make three steps first insert into the destination database second update the source the third step when the operation fails insert to third table but this step should be related together on one task.. and this procedure is created on the source.MobashA |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-14 : 10:18:43
|
| Why need dts if you have sp for those steps already? |
 |
|
|
mobasha
Starting Member
45 Posts |
Posted - 2007-05-14 : 15:21:48
|
| am tring to use DTS to connect to the data bases cos am using linked serversMobashA |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-14 : 23:29:59
|
| You can access linked server in sp. |
|
|
|
mobasha
Starting Member
45 Posts |
Posted - 2007-05-15 : 01:54:25
|
| i know and i did ,but my supervisor need a second way..thats allMobashA |
|
|
|
|
|
|
how to modify two data bases in one task?