Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ODI Bulk Load from Oracle to Sql server

1009273Jan 12 2017 — edited Mar 15 2017

I'm loading the data from oracle to sql server using LKM sql to MSSql (Bulk) & IKM Control append.

So when i'm trying to execute the mappings its throws me an error.

ERROR:- Bulk load data conversion error (truncation) for row 1929003, column 88 (at Load data(Bulk Insert) step)

ERROR:- Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 1922194, column 88

Can you please suggest me on this and I tried changing the Row terminator= '\n' & '0x0a' in Knowledge Module & in flow tab Field_separator = ","

but no luck.

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 9 2017

Added on Jan 12 2017

#business-intelligence-applications, #data-integrator, #system-management-and-integration

1 comment

780 views