June 16, 2009 at 9:56 pm
Hi guys, my name is Ryan. I have a problem in my SSIS package.
I've built a SSIS package that transfer some data from oracle using sql command, to sql database. The problem is, the data from the oracle didn't match when I transfer it to SQL database. for example in the oracle the data is : 0.89769 but when I transfer it to SQL it returns just zero (0), is not the same. I already try using Data Conversion, using float data types, but still it didn't work. So can you guys help me, please. Btw, the data type in the SQL table is float also.
Thanks in advance,
Ryan
June 16, 2009 at 11:27 pm
Hello Ryan,
Does the following link describe a similar issue to the one you are experiencing:-
http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=286695
Regards,
John Marsh
www.sql.lu
SQL Server Luxembourg User Group
June 18, 2009 at 12:54 am
HI john, thanks for the reply. I already checked your link, but still I don't get it, from what I read from your link it was a bug in the SQL, am I correct or not, please let me know. I'm still a newbie for this SSIS thing, so maybe you have any idea to solve my problem. By the way, I already tried to use convert and cast in my oracle query but still the numbers in my SQL table are 0 instead of 0.12345 (for example). I also did some settings in the precision and scale, in the oracle table the datatype is NUMERIC [DT_NUMERIC] precision : 38 scale : 0--based on SSIS advance editor. So I tried to change my SQL table datatype to Numeric also with precision and scale matcing the oracle column, but it still not working, gosh. It really start to bugging me out. So maybe if any of you guys, out there have a solution to break this problem, I really do appreciate it.
Best Regards,
Ryan
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply