Thanks for the reply. I've never created a linked server in code before. I'll look into that. Sounds like a good option.

With regards to the DTS vs TSQL comment, you lost me somewhere in the double negative. I was trying to say, if it can be done with a dts package, it can be done in tsql script.