When using Microsoft Dynamics CRM, you will come across cases where you might need to populate the Parent Customer ID field using KingswaySoft.
A common mistake that occurs is when people try to use this to populate the parent customer ID field only. If so, they will receive this error message:
“Error: 0xC0047062 at Data Flow Task, Dynamics CRM Destination : System.Exception: An input for ‘parentcustomeridtype’ field is required in order to process lookup field ‘parentcustomerid’ correctly. The input value should be one of the following entity names, or its corresponding entity type code in integer format: ‘account’, ‘contact’. (Integer type code is the only option when SOAP 2007 or 2006 is used).
at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostPreExecute(IDTSManagedComponentWrapper100 wrapper)”
When you use SSIS the error will be under the insert/update data section as shown below:
In order to solve it, we will need to make sure that the Parent Customer ID type is also being populated. If the parent customer is a contact, the value in the field will be a Contact record; if the parent customer is an account, the value in the field will be an Account record.
We hope this blog was helpful! If you interested in learning more, please check out our other related Dynamics CRM blog topics such as:
- Optimizing SQL Integrating Services (SSIS) with MSCRM
- Optimizing SSIS with Microsoft Dynamics CRM
- Creating a Custom Filtered Lookup in CRM 2011