Now we have a new wrinkle... the upgraded Oracle client was installed on the machine with the sql server, and ever since, our jobs running DTS packages fail.  If we run...

What I've done is to open each package in design view and save it off as a VB Script.  Then, when I need to bring them back in, I either...

Thanks for your help.  I have long suspected that a linked server would solve many of the problems we're having.

I've had a request in for a linked server for a...

The best way I know to understand a table is to picture each row of data as a marble and the table as a bucket.  Dump all 7 million marbles...

In response to the first item in the thread, which I responded to first, but it isn't showing on the thread, but the second response to the delimiting question did...

I...

Can you set the around text to none?