Thanks everyone for the very helpful responses.

We got rid of the Warning messages by selecting DontSaveSensitive Protection Level at the Project Level and Package Level. Now, when a developer opens...

Does anyone have any suggestions to this post.

Thanks, Kevin

Got it to Work!

--With Linked Server and OpenQuery() Function.

----Use getClobVal() to retrieve XML data as CLOB value in Oracle Query.

----Use CAST to cast from char to xml in SQL...

Thanks again Jo. However, it is already in xml format on the oracle side.

--Not Working:

--The SYS_NC_ROWINFO$ Column is xmltype with HUGECLOB in the data columns (when looking at the data...

Thanks Jo. This helped me get farther down the road. The fist sql statement below works. However, with the second sql statement, I am getting an "ORA-00932: inconsistent datatypes: expected...

I got around the "Table does not exist" error by changing the Data Access Mode to SQL Command and using SQL Code to access the table without the double quotes....

Ok, I am back to researching this issue. Thanks everyone for your responses.

It appears I was able to load Oracle Data (non xml) into SQL Server using the Linked...

Just wondering if anyone had any input on this issue?

Thanks, Kevin

Thanks Erland.

Thanks Erland and Dennis. It works for me ... must have been confusing myself. However, I had to change the schema owner to dbo in order to assign permissions ......

Thanks for the responses. Steve what do you mean by +1?

Thanks prvmine. Installing the Oracle 32-Bit Client resolved the issue. Just wondering why Microsoft has not come up with 64-Bit Development Tools (BIDS, VSS, etc.)?

Thanks, Kevin

Thanks Ness. So, I guess "Principals with CONTROL permission on a securable can grant permission on that securable.

Grantees of CONTROL permission on a schema can grant any permission on any...

Thanks Calvo and Grant. Just wondering what are the benefits of creating additional databases verses additonal schemas within a database? I see the advantages of schemas (object name resolution,...

Thanks GilaMonster.

Per your statement "No way to tell really. TempDB isn't the same as Oracle's redo space, so you can't use that as a basis."

Just based on the Oracle...