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)
