Thanks, that's what I thought.

Christine

Yes Antares686, I started that thread as well. Discussing the very same issue 🙂

Thanks

When you create your link server, check the following items:

1. Be sure the Link_Server is called the same thing as your data source name in ODBC.

(By the way did you...

You have been so helpful, thanks. I am working with brand new servers, at least 40GB hard drives, 1GB of RAM, 512 Cache, Dual Pentium III 1GHz processors. ...

I am moving data from a staging dB to a datawarehouse, I gave the wrong information above, I actually do a few data type conversions but that's all. I...

Thanks for your response. Sadly though, I am not doing ANY transformations and it still takes this long. Could it be issues not even related to SQL Server...

Well I am moving data from a staging dB to a datawarehouse. (Unfortunately, no straight copy). The thing is I am moving less than 2GB [initially, eventually will...