You’re offline. This is a read only version of the page.
Hi,
I'm using Kingsway Software to integrate between Dataverse and SSIS/SQL Server on premise. I have been able to create a connection manager. I created a Dataflow in which I have SQL Server as source and Dataverse as destination (with Kingsway Software).
I get the following error message while executing:
Error: 0xC0047062 at Data Flow Task, Dynamics CRM Destination [2]: KingswaySoft.IntegrationToolkit.DynamicsCrm.CrmServiceException: CRM service call returned an error: An error has occurred when retrieving metadata for CRM entity 'cr474_shpkpi_values_extended': CRM service call returned an error: The remote server returned an error: (400) Bad Request. (Error Type / Reason: BadRequest) ---> KingswaySoft.IntegrationToolkit.DynamicsCrm.CrmServiceException: CRM service call returned an error: The remote server returned an error: (400) Bad Request. (Error Type / Reason: BadRequest) ---> System.Net.WebException: The remote server returned an error: (400) Bad Request.
at System.Net.HttpWebRequest.GetResponse()
at myv.oxl.mko()
at nnk.slp[cs](Func`1 mpk, Int32 mpl, nnl mpm, Boolean mpn)
at myv.gvv()
at myv.gvs()
at nim.hdh(Boolean mpk, Nullable`1 mpl)
at nim.sqx.swz()
at nnk.slo[cs](Func`1 mpk, Func`2 mpl, Int32 mpm, nnl mpn)
--- End of inner exception stack trace ---
at nnk.slo[cs](Func`1 mpk, Func`2 mpl, Int32 mpm, nnl mpn)
at nim.hdc(OrganizationRequest mpk, Boolean mpl, Nullable`1 mpm, PipelineComponent mpn, Nullable`1 mpo, Int32 mpp)
at nim.hcd(String mpk, Boolean mpl)
--- End of inner exception stack trace ---
at nim.hcd(String mpk, Boolean mpl)
at nim.hbl(String mpk, Boolean mpl, Boolean mpm)
at nim.vnm(String mpk)
at nim.voj(myz mpk)
at KingswaySoft.IntegrationToolkit.DynamicsCrm.CrmDestinationComponent.PreExecute()
at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostPreExecute(IDTSManagedComponentWrapper100 wrapper)
Thanks all for replying, I finally found the solution. The issue was in a Security Setting, Protection Level for the Package. This was set to "Don not save sensitive data", any other setting than that one fixed the issue..
Thanks for your response.
I indeed tried that without success unfortunately...
Best regards,
Piet
Hi @PietPoelsma,
Can you try clicking the Refresh Metadata button on the destination component? You'll want to do that any time there may have been changes to that table in Dataverse.
---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.
Hi @gowrihalan04 ,
Tanks for your response.
I can't see how I could get the wrong schema name, as the table name has picked from a drop down list. Also when I try to map the columns, I get all the column names from the destination table in the Dataverse, so the meta data can be read, as you can see below
Kind regards,
Piet
Hi @PietPoelsma Check if the entity schema name is correct. error says Tool could not find metadata of entity you provided.
Hi @Mira_Ghaly
Thanks for responding!
Authentication Method: OAuth
Test Connection was successful.
Kind regards,
Piet
How are you authenticating the connection Manager? Did the Test connection succeed?
#1
WarrenBelz
791
Most Valuable Professional
#2
MS.Ragavendar
410
Super User 2025 Season 2
#3
mmbr1606
275
Super User 2025 Season 2
Share
Report
All responses (
Answers (