Somehow the TransactionOption had got set to "Required" on the first container, but not the others.

Setting it back to...

I found a fix for our issue in disabling loopback checking via modification of the registry.

How did you resolve this issue? I'm having a similar problem. Was able to access reports fine until we added a certificate and started to use SSL etc. How it...

Explain plan and resource consumption reports on the Oracle side actually slightly favor the non-dynamic SQL version, although the difference between the two is negligible.

That's not serious benchmarking, just running...

Jeff,

Thanks for this. I must say that I'm a bit surprised that it is really usable. It looks like it would pull the entire table over from Oracle to SQL...

Thanks, Joe, once again.

I just came back to report that I had resolved it in exactly that way. And you beat me to it.

Allow In Process - I had checked that when working with MSDORA but forgot with OraOLEDB.

I checked it, restarted the instance, and now I'm getting data back using "Openquery!"

But...

I have installed the Oracle OLEDB provider and am now using that. Connection test successful, but when I run a query with openquery, I get this:

Msg 7399, Level 16, State...

When I use Openquery, I get a similar but different error:

Msg 7357, Level 16, State 2, Line 1

Cannot process the object "SELECT TERM

FROM [OraStud]..[StudOwner].[STUDENT_DIRECTORY_INFO]

WHERE studid = '9170'"....

This would run business daily. Oracle can have network encryption turned on, and I'm checking to see if that's the case here. As far as SQL Server, installing a certificate...

Yes, the helpful hosts had some routine scheduled that was supposed to be of assistance in some way.

I have asked them to desist.

Thank you for your response, Gail.

ok, let's try a simple single question. Does SSIS, when pulling from an XML source, create a "pseudo" column of sorts as an identifier?

I'm seeing such a column which is...

Somebody's got to have an answer!

Besides the datatype conversion issues described above, another question.

I ran a validator on the xml file against its xsd definition, and it got a passing...

When I try to create a table from the XSD I figured that there would be no import issues ... but no, I still have to use data type converter....

Try to get a more complete / accurate copy of the error message.

You must be able to connect both to Oracle and SQL servers if you are reading table structure...