February 5, 2014 at 3:26 am
I am creating an SSIS package. The package reads data from a table in Oracle and then inserts it in table in SQL Server. I am using Attunity to connect to Oracle and get data.
One of the field in Oracle table is a calculated/formula field and it stores numeric values. There are other fields in table too which are also numeric but they are not calculated/formula fields.
Problem is when I read data from calculated/formula field then it reads wrong values such as:
1867
-1867
-1861
So let's say if there are 500 records, then all records will have above values in that particular field. It's all random and sometimes it inserts 0 in it.
The other numeric value fields are working fine. I tried doing CAST but no luck. Even if I do not insert data in SQL Server and instead just take a preview of data in Oracle by clicking "Preview" button then it shows wrong data.
How to solve this issue?
February 5, 2014 at 3:34 am
Do you get wrong data if you connect with the regular OLE DB source?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 5, 2014 at 3:41 am
Koen Verbeeck (2/5/2014)
Do you get wrong data if you connect with the regular OLE DB source?
Haven't tried with OLE DB. Will try and then see what happens.
February 5, 2014 at 3:51 am
Using OLEDB fixed the problem. Looks like Attunity driver is buggy.
February 5, 2014 at 4:02 am
frank_martinboy (2/5/2014)
Using OLEDB fixed the problem. Looks like Attunity driver is buggy.
OK, good to know.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply