Homemade SSIS load balancer for large data loads
When you need to import hundreds of thousands records, it can take a long time to import with the KingswaySoft destination. This can be a serious issue, if a large data load is part...
Tagged: SSIS
SSIS Basics: Merge join
For this small how-to, I’ll go through how to use the Merge Join in SSIS. The Merge Join is used for joining data into the a single row from two different datastreams. A basic...
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...
Split fullName into first- and lastname in SQL, Excel and SSIS
This is something I find myself doing over and over and over again, when importing data to CRM, seeing as CRM wants the contacts as Firstname and Lastname. And the data I receive is...
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
Error installing SSDT for VS2017: Failed to acquire payload
I recently had to install VS2017 with KingswaySoft on a computer, and I ran into some issues in regard to the installation. After I had installed the Visual Studio software, I needed to install SSDT (15.5.0).
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...
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...