In attempting to import an excel sheet with contact data using the DTS, The OCS_ID field is raising a number of problems. The columns in the excel sheet have been named after the fields in the .CONTACTS table for easy mapping. There is no mapping for the OCS_ID field. When I attempt to do nothing with the OCS_ID field, I get the following error:

"Error at Destination for Row number 1. Errors encountered so far in this task: 1.
Insert error, column 1 ('OCS_ID',DBTYPE_GUID), status 10: Integrity violation; attempt to insert NULL data or data which violates constraints.
Unspecified error
"OK"

I have tried performing several transformations, generally in the form

Function Main()
Declare myID as uniqueidentifier
set myID = NEWID()
Destination('OCS_ID') = myID
{followed by the automatically generated destination=source statements.

Do you have any hints or tips, how I can get the contact information imported?

If you are using DTS, how is this problem related to GeniusConnect?

Without GeniusConnect, this process would not be necessary. I know this is not directly related to GeniusConnect, but I thought I would see if there was some stupid thing that I overlooked. It might have been that this issue was raised before.
Sorry for the bother.

"Insert error, column 1 ('OCS_ID',DBTYPE_GUID), status 10: Integrity violation; attempt to insert NULL data or data which violates constraints."

just define a default value for the OCS_ID column in SQL Server.
Default:
newid()