I got a requirement do develop integration between Dynamics 365 and 3rd party data warehouse. Here I have to use SSIS for Integration. Obviously when you want to write data to Dynamics from SSIS, we need to use Kingswaysoft SSIS Components. So, I have retrieved the data from the files coming from 3rd party warehouse and writing the data in to Dynamics using Kingswaysoft Destination component.
During the implementation, I had to create a new entity in Dynamics 365 CE as below and configure it in Kingswaysoft adapter.
But I was unable to select the newly created entity in Destination Entity inside the destination component editor as below. I tried refreshing metadata, rebuild the solution, closed visual studio multiple times, cleared the cache but none of them helped. As shown below. I was not able to select the respective newly created entity.
I was unable to get that even after 2 days…I tried to create another package and set the Kingswaysoft SSIS Destination editor, so here I am able to see the newly created entity. There comes the fix.
So here are the two ways how you can do it using the same SSIS Package itself without using another.
- Step: If your connection manager uses SOAP 2011 (Dynamics 365 CE, Dataverse, CRM 2016, 2015, 2013, 2011) …then you can create one more connection with the same configuration.
Then you should see something like below in your connection manager’s section.
Just delete the old connection and rename the new connection to old connection manager name and update the lost references at all places in your package.
2. Step: Change your service end point to Web API as highlighted below
Just update any missing references…that’s it….
Thank you for reading…if you have any issue on the same, please let me know..