Oracle Database Free

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!

SQL 2022 to oracle (23.1.1) datatype conversion

sugi balaMar 1 2024

HI ALL,

I am trying to import data from SQL 2022 (restored data into this server) to oracle db via SSIS (VS 2019)

I have unique identifier dataype in SQL with data like 147834E5-EE5F-4621-86FC-326F826EA48A

I am trying to import the same in oracle db with datatype as RAW(16), but it gets error as conversion problem.

IS it only way to convert to nvarchar from SQL while importing in data flow task of ssis. (like convert(nvarchar(100),ColumnName))

please suggest can i take data directly as with same datatype too?

also please share datatype conversions for XML data present in sql.

Added on Mar 1 2024

5 comments

388 views