Composing and Decomposing Data in SSIS

02 October 2020
Mohamed Abdalkarim

When integrating data between different applications or database systems, what do you do when certain fields hold data in a different format than what the target system is expecting? This blog post will demonstrate how using our latest components within the SSIS Productivity Pack, Composition and Decomposition, you can parse each individual value from a delimited text form with ease.


Migrating Dynamics CDS/CRM Quote with Revisions in SSIS

16 September 2020
Chen Huang

In a prior blog post, we explained how to migrate quotes from one Dynamics CRM system to another however it only focused on the most recent quote. In this post, we expand on that migration and show you how to use our software to migrate Dynamics CDS/CRM quotes with revisions in SSIS.


Salesforce Attachments Integration with Microsoft Team Foundation Server

17 August 2020
Mohamed Abdalkarim

Extracting and integrating attachments from Salesforce or Azure DevOps (formally Team Foundation Server) can be useful when moving attachments to different cloud storage or syncing the attachments between different systems. In this blog post, we detail how to extract attachments from both systems as well as write attachments to them.


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.

comments powered by Disqus