Integrating with SSIS using KingswaySoft

SQL Server Integration Services (SSIS) is a great choice when building complex ongoing inter-system integrations or complex one-off data migrations. KingswaySoft offers a Microsoft Dynamics 365 Integration product that provides Dynamics 365 specific add-ons to the base SSIS toolset. KingswaySoft add-ons turn complex Dynamics 365 web services integration into high performance, easy-to-use, point-and-click configurable data integration solutions. Daniel Cai, Microsoft MVP and a personal inspiration to me becoming a business solutions MVP, is one of the masterminds behind this product.

In this recipe, we will cover a simple scenario, reading the account records from a CSV file and upserting (update or insert if the record is not found) them into Dynamics 365 with a custom-defined primary key. We will also deal with redirecting errors to a separate flat file.

Getting ready

For this recipe, you will need Visual Studio 2015 with SQL Server Data Tools (SSDT...