Yikes. I'm just trying to do the same thing I could do in 2000 for free! So, do you know that it is not possible to do this...

Yes, I have Managment Studio, but I can't see the Oracle objects there. What is Embarcadero DB Artisan? Is that software I have to buy?

--Susan

Using Begin Distributed Tran did not solve the problem. However, I did solve the problem by using a table variable instead of a temp table. I don't know...

I just reported this on Microsoft's site. I searched their bug report database and didn't see it. Hopefully they will eliminate this "feature" in the next patch.

That's it -- it is all about the DTS window. Why? Is this fixable?