Steve Chan 15.Mar.06 06:39 AM a Web browser LEI LEI - 6.0 Windows 2000
I am trying to get information from Notes into a SQL db. This has been fine when I have only being transferring form date, but now I want to pass some subform data as well.
This is a Direct Transfer job.
Notes Connection Document
When setting this I make sure that the 'General Tab', 'Use Computed Subforms' has the name of my subform. I then go onto 'Document Selection', choose the document and the fields I want. However, I do not see the subform fields on this list so I cannot select them.
OLE DB Connection Document
Setting it up is straight forward and I have ensured that the new fields are included by rechoosing the view.
Direct Transfer Activity Document
I have refreshed the Source and Target to ensure and then remap the fields. The subform fields I want are now visible in the Data Mapping popup box.
Once it is all mapped I run the job and this is the error I get:
Error: Field mapping failed due to a missing field xxxx
I have tested this by selecting a field from the form and putting it into my new SQL field. This works. When I resubstitute the form field for a subform field the error comes back.