Installing Visual Studio 2017 and KingswaySoft
I have previously writting about an error I recieved when I attempted to installed SSDT for Visual Studio 2017. But with the new version of SSDT, Microsoft have seemingly fixed the bug, and you can now easily install SSDT with Visual Studio 2017. Firstly, you need the installer for Visual Studio 2017 (community works fine) […]
Using KingswaySoft to migrate ClickDimensions
I was tasked with migrating a ClickDimensions solution from one Dynamics 365 to another Dynamics365 (both version 9.0). The only differences were, that it was a different CRM tenant and a newer version of ClickDimensions
KingswaySoft Spring release v10
KingswaySoft recently released their spring 2018 release marked as version 10. This release introduces numerous awesome changes, which makes data integration and transformation a lot easier and seamless. Some of the changes include: The CRM Source component now includes a SQL to FetchXML converter which allows you to convert SQL script to FetchXML query directly […]
KingswaySoft winter release (v9.2)
KingswaySoft just pushed out their Winter release for the Dynamics 365 toolkit (version 9.2), which primarily contains fixes in their toolkit. One of the bugs it fixes, is something I ran into myself. When using an upsert action to an N:N Destination, it can cause an Object reference error. I recieved a hotfix from KingswaySoft […]
Cross join in SSIS
Lately I’ve been working a lot more in Dynamics365 than I have onPremise, and for the most part, the online CRM offers some very cool customization options, but there are scenarios, where I really would love access to the database, when performing data transformations. The fact that we can’t simply connect to the database for […]