Okay, this is not the result I am getting so I may have something set wrong in my DTS.

I have the c(38) nocptrans field. I run the DTS wizard. I pick uniqueid for that field.

I run the DTS and I get this error:

DTSTransformCopy: Schema validation failed. See extended error information.
TransformCopy 'DirectCopyXForm' validation error: ForceConvert not specified but
required for column pair 13 (source column 'pk_supplier'
(DBTYPE_BYTES),destination column 'pk_supplier' (DBTYPE_GUID)

Any idea how to specify ForceConvert ?

>Charles,
>I didn't have VFP and SQL server on this box so it took me sometime to install them and test:)
>I created a database in VFP with 3 tables in it. Those 3 tables had c(38),c(36) and c(16) nocptrans versions respectively.
>In SQL server DTS I directly mapped 36,38 ones to uniqueidentifier and 16 bytes one to varbinary(16). All imported sucessfully. After import I changed type of 3rd one to uniqueidentifier.
>Checked values in both VFP and SQL server and they matched.
>Cetin
>
>>>I think we're losing to be synch in "upsizing".
>>
>>Yani, "out of synch" (free English lesson in return for code lesson :-)
>>
>>Okay, I think I am starting to get what you are saying. ( still don't understand pguid and rguid as you use them but maybe I don't have to in order to use the function. ) I did understand we were talking about using code on the VFP side to 'upsize' and not to use the wizard.
>>
>>I did try converting the c(36) guids to c(38) including the brackets. If I do that the DTS transformation allows me to select UniqueID as the destination data type, but the import fails saying that a forcedconversion is required and I can't find out how to do that. ( will go back and try again on the DTS wizard )
>>
>>Let me play some more and I will come back with more questions.
>>