Hi,
I am trying to interface to an Oracle database through SQL Server Integration Services using the Oracle 11g ODBC Driver. I've also tried the 12c driver. I am trying a simple select query which is failing with a "Disconnected recordsets are not available from ODBC connections" error.
The query is as simple as I can make it:
select 1 as one from dual
I had previously being using a OLEDB connection which worked fine but I am trying to standardise on ODBC so that I don't have to mix data connection technology and i have hit this error.
Is this a known limitation in the ODBC Driver? Would an upgrade help?
I felt this was more of an Oracle question than SSIS. Thanks in advance.
David