Oracle.Oledb provider returning improper out-put (Network Steve Forum)

Oracle.Oledb provider returning improper out-put

Dear All,

Need your help in below issue.

I have SSIS package which pull data from Oracle to SQL Server.
Currently I have used Oracle.Oledb provider for the same, but it is giving me improper result.

I check on oracle end count for that table was 26000 and when I run the same query through SSIS it shows 0 rows.
The preview of the query is showing 0 as output.

but when I tried the same using Microsoft OLEDB provider for Oracle it giving me proper out-put

March 25th, 2015 9:03am

Microsoft OLEDB Provider for Oracle will only work if the Oracle database is on a Windows Server.

Have you got oracle Client software installed on the Server from where you are running and have you configure tnsnames.ora?

Free Windows Admin Tool Kit Click here and download it now

March 25th, 2015 9:07am

Hi Susant,

the following article has the solution

http://www.sqlchick.com/entries/2012/9/2/resolving-missing-records-in-ssis-from-oracle-source.html

In essence, revise the connection string to append

;UseSessionFormat=True

March 25th, 2015 9:16am

Hi Arthur,

Can you please tell me from where to set UseSessionFormat=True.

I Have SQL Server 64 Bit and Oracle client 32 bit on server

Free Windows Admin Tool Kit Click here and download it now

March 26th, 2015 12:55am

This topic is archived. No further replies will be accepted.