ETL and Data Integration tools - Modern ETL software for everyone

Hello,

I am trying to extract data from an MS SQL server in insert into Oracle. All fields are extracted correctly, except for fields that are defined as unique identifiers in MS SQL. For some reason, these fields are not populated in VI. The Visual Importer version is 7.7.6.6. You can see in the attached screenshot that the Unique Identifier field in this case (in both the source and target fields which are 1 and 13) are blank. If I use InfoMaker to check the table on the db, the data is there. I have tried mapping and remapping, but this does not resolve the issue. I am close to the end of my trial period for the software, and I have already designed my current project around VI, and don't have the time to replace it now. Any help appreciated as to why this is happening. Is this a bug?

msdn.microsoft.com/en-us/library/aa223933%28v=sql.80%29.aspx

The uniqueidentifier data type stores 16-byte binary values that operate as globally unique identifiers (GUIDs). A GUID is a unique binary number; no other computer in the world will generate a duplicate of that GUID value. The main use for a GUID is for assigning an identifier that must be unique in a network that has many computers at many sites.

Since it is binary some of the characters are unprintable therefore you can't see the data

As a work around you can use cast or you can use ole db connection instead of MS Sql connection

select cast(field_name as varchar(100)) from table

Mike