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.
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
Thanks Prateek for your response.
we can see all the UNIQUE identifiers are used as lookups in CRM. So we tried to unmap the lookup columns an retriggered the job. still it is failed and the error is going by property by property . and as you said, I tried to unmap the createdbyexternalparty column, even the issue is still there. Below are the list of columns we tried to unmap and rerun . But NO LUCK.
Thanks,
Ganesh Kandi
+91-9553444334
What are column selected in the source? If createdbyexternalparty is present - did you try removing it?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,802 Super User 2024 Season 2
Martin Dráb 229,133 Most Valuable Professional
nmaenpaa 101,154