Anyone who can help me the solve the strange problem

Hi,

i encountered a very strange problem when using SSIS, the oledb source convert some fields in retrieving the data from oracle database,the datatype of the target field is NUMBER(5,1), and all the data retrieved from it have the uniform 'x.y', and remained same when i previewed the data in the oledb source,but the output of the data changed to 'x', the data converted to integer, anyone knows how to solve the problem please let me know, thanks a lot.

Where is this output that you are looking at ? The output of the OLE DB Source?

If so, it could be that the externl columns have been mapped to the wrong pipeline types. Check this out in the OLE DB Source Advanced Editor.

-Jamie

|||Do you have anything between the source and destination that might be converting the data?|||

Jamie Thomson

thanks for your kindly help, the problem i mentioned above has been solved.

|||

icewill wrote:

Jamie Thomson

thanks for your kindly help, the problem i mentioned above has been solved.

Icewill,
I 've the same problem, question how did you solved it?
Thanks in advance.
Olaf