Manipulate CRM ActivityParty Field Values

12 May 2020
Mohamed Abdalkarim

Manipulating input data can be challenging when working with the JSON format of CRM's ActivityParty fields. Let us take you through the process.


Joining Parent and Child Records Efficiently

14 April 2020
Aswin Manmadhan

Dealing with more than one output from a Source component? Most likely your endpoint has parent and child records. Let's show you how to join these records efficiently.


Working with Dynamics 365 Business Central/NAV Codeunit in SSIS

04 March 2020
Chen Huang

Explore working with Dynamics BC/NAV Codeunit web service by using HTTP Connection Manager and Web Service components offered in our SSIS Productivity Pack.


Using KingswaySoft Components for Error Handling and Logging

13 February 2020
Mohamed Abdalkarim

When designing an integration package, you'd expect to run into errors that may break the execution of one of the tasks or even the entire package. In this blog post, we explore the different approaches of handling and logging error messages while sending notifications for either a record-level or a package-level failure.


Running SSIS Integration Toolkit on the Cloud

30 April 2018
Daniel Cai

In this blog post, we specifically discuss how you can deploy our software and run it in Azure SSIS Integration Runtime (IR) by leveraging our most recent Spring 2018 release.


Migrate CRM close or resolution entity records in your ETL process

31 March 2017
Daniel Cai

Microsoft Dynamics 365/CRM uses some close entities to capture the reason why the primary record was closed with some additional information. In this blog post I discuss how to migrate CRM close or resolution entities in your ETL process properly to avoid creating duplicates for those entities in your target system.


Migrating old CRM KB Article data to the new Knowledge Article

21 June 2016
Chen Huang

In this blog post, we will demonstrate how to use our software to migrate old KbArticle data to the new knowledgebase along with taking care of the versioning issue by creating new knowledge records and updating the latest version of the existing article records.


Using CRM Alternate Key(s) for Lookup Purpose in SSIS

16 May 2016
Daniel Cai

CRM 2015 Update 1 introduced the Alternate Key feature which can be used for Update and Upsert function as an alternative way to identify a CRM record in addition to the primary key. However there is one more scenario that this feature can be useful as well, but may have been overlooked, which is to use the Alternate Key for lookup purpose. In this blog post, I will show you how we have enabled the feature for lookup purpose.

comments powered by Disqus