Migrating E-Mails from Goldmine

[papaio...@dotcy.com.cy]

I am trying to migrate e-mails from Goldmine to CRM 3.0 using the data
migration framework. In Goldmine, e-mail body is stored in a field
called RFC822 in table MAILBOX. The RFC822 field is a 'text' field. In
CRM 3.0 DMF, I need to insert the e-mail records in the cdf_EMail
table. The RFC822 Golmine field needs to go to the 'Description' field
in cdf_EMail (this is an ntext field).

I am using INSERT INTO ... SELECT FROM kind of statements to select the
necessary fields from Goldmine that need to post in cdf_EMail.

The problem is with the RFC822 field. If i run the DMF data migration
routines while the 'Description' field is populated with the 'RFC822'
field, no e-mails get migrated and the process finishes in a few
seconds without processing the e-mails. However, if I UPDATE cdf_EMail
set Description = 'This is a sample e-mail body' and then I run the
migration routines, the e-mails get migrated to CRM 3.0 with no problem
at all !

>From the above, I believe there is an issue with the data I am
populating the 'Description' field with (this is usually RFC822
protocol based data - HTML format like). Seems like the migration
routines do not like this field to be populated with real (and long)
data.

Has anyone had similar problems ? Any suggestions on how to overcome
this issue will be greatly appreciated.

Thanks

Nicos Papaioannou