Skip to Main Content

Oracle Database Free

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

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.

Comments
Post Details
Added on Mar 1 2024
5 comments
146 views