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 |
|
ccrespo
Yak Posting Veteran
59 Posts |
 Posted - 2007-08-14 : 11:40:31
|
| Does anyone know which one is faster? I succesfully have a DTS Package that connects to an oracle 10g db. Any instructions on setting it up as a linked server? |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-08-14 : 11:42:08
|
| use dts.linked server will start distributed transactions which can slow down the whole process._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
 |
|
|
|
|
|
DTS vs Linked Server