Skip to Main Content
Forums

SQL & PL/SQL

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!

Convert Varchar datatype column to SQL server Unique Identifier datatype

2831274Dec 31 2014 — edited Jan 1 2015

I have a column declared as a Varchar2 datatype, I need to load the data into my target DB SQL Server table with column datatype as Unique Identifier .

When I try to load the data I get the error as "Conversion failed when converting from a character string to uniqueidentifier."

Can someone guide what datatye should we convert the varchar to so that it can be loaded into target Unique Identifier column.


Thanks,

Ram.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 29 2015
Added on Dec 31 2014
2 comments
723 views