March 25, 2015 at 4:22 am
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.
March 25, 2015 at 5:43 am
Did you write a query? What did you use as a source in the data flow?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 25, 2015 at 6:04 am
I have used OLEDB source in data flow and then written query with where clause to select data from oracle.
March 25, 2015 at 6:27 am
Sushant Yadav (3/25/2015)
I have used OLEDB source in data flow and then written query with where clause to select data from oracle.
Does the preview return 0 rows as well?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 25, 2015 at 6:48 am
Yes 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 25, 2015 at 7:07 am
Sushant Yadav (3/25/2015)
Yes 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
Did you install the correct versions of the Oracle OLE DB provider? (32-bit AND 64-bit?)
I never had issues with the provider before.
The Microsoft OLEDB provider for Oracle is 32-bit only and deprecated as well.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 25, 2015 at 10:55 pm
I found following link for the issue.
http://www.sqlchick.com/entries/2012/9/2/resolving-missing-records-in-ssis-from-oracle-source.html
but didn't get from where to set UseSessionFormat=True.
I Have SQL Server 64 Bit and Oracle client 32 bit on server
March 27, 2015 at 9:21 pm
Dear All,
found solution for this issue on below link.
March 30, 2015 at 2:12 am
Sushant Yadav (3/27/2015)
found solution for this issue on below link.
Right. I have encountered the same issue before. I even blogged about it:
The OLE DB Source and the Oracle Date Literal[/url]
Maybe next time post the query as well when you have an issue 😉
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply