Ok, I'm dumb... My login on the sql server is different from that on the oracle server. different id naming conventions for different departments... love this company.

It doesn't look...

I just transform between an MS OLE DB for oracle connection and a conn for the sql server... Now that I think about it, it seems that I could...

well, nevermind on the openquery, our sql server does not have rights on either oracle server. That would be a phenominal amount of red tape, unless there is a way...

I'd love to load both to SQL Server, but only the barebones-necessary data from both db's needed for the merge is estimated at over 4 GB, and I don't have...