issues with uniqueidentifiers
Hi there I am a newbie to SSIS. I try to load data from SQl Server to Oracle. When I try to map a unique identifier datatype in SQl Server to string datatype in Oracle, I get curly braces in the end result. 9CF03E8F-83D1-4938-920B-000257219711 - in SQL Server {9CF03E8F-83D1-4938-920B-000257219711} - in Oracle I also wanted to know what is the matching datatype of Unique identifier in Oracle. In SSIS, I converted UID to string datatype. Any sugestions welcome. Thanks in advance
January 20th, 2011 1:28am

I dont think there is an equivalent in Oracle for GUID. what you can do is convert the GUID to string and remove the braces and then upload to oracle.
Free Windows Admin Tool Kit Click here and download it now
January 20th, 2011 1:38am

thanks Sudeep
January 24th, 2011 12:38am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics