Hello,
I am getting issue with CRM kingsway component in SSIS packages . currently I am updating the CRM configuration from SOAP2011 to WEBAPI .
We are getting issues at source CRM kingsway component in our package . SSIS package is extracting the data from CRM and loading it to SQL table. but In CRM source connection we are using the entity changes source type. and also some columns are lookups . it is failing on each lookup columns with the below error when we try to execute the package.
[Dynamics CRM Source [1631]] Error: An error occurred with the following error message: "KingswaySoft.IntegrationToolkit.DynamicsCrm.WebAPI.WebApiServiceException: The remote server returned an error: (400) Bad Request. (Error Type / Reason: BadRequest, Detailed Message: {"error":{"code":"0x0","message":"Could not find a property named 'createdbyexternalparty' on type 'Microsoft.Dynamics.CRM.account'."}}) (SSIS Integration Toolkit for Microsoft Dynamics 365, v20.1.1.2391 - DtsDebugHost, v13.0.5888.11)System.Net.WebException
and below is the snip for CRM connection in ssis package
Please suggest any inputs to resolve this as this needs to be done in our production environment ASAP.
Appreciated if anyone wants to discuss with me on this .
Thanks,
Ganesh Kandi
+91-9553444334
