Performing File Upload Using HTTP Multipart Requests in SSIS

19 February 2021
KingswaySoft Team

In this blog post, we will discuss how to perform file upload using HTTP multipart/form-data format in SSIS without having to write a single line of code.


Parsing Advanced JSON Structures with Ease Using SSIS Productivity Pack

16 February 2021
KingswaySoft Team

In this blog post, we will be going through some complex JSON document structures and demonstrate how to configure KingswaySoft JSON Source/Extract component to extract data from those JSON documents efficiently.


Paging REST requests in SSIS using KingswaySoft JSON Source Component

14 January 2021
Chen Huang

In this blog post, we will be going through some of the most common API pagination methods and demonstrate how to configure KingswaySoft JSON Source component to send out the paginated requests in SSIS.


Composing and Decomposing Data in SSIS

02 October 2020
KingswaySoft Team

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.


Real-Time Salesforce Integration with Virtually Any Application or Database System

10 September 2020
KingswaySoft Team

Real-time data integration is now essential for immediate decision making by businesses across the world. With modern-cloud based services such as Salesforce and our Integration Gateway solution, integrate your Salesforce data with any application or database system in real-time.


Extracting Key/Value Pairs JSON Structure into Tabular Format

02 September 2020
KingswaySoft Team

When working with JSON data, a scenario may arise where there could be a format of a JSON Document that makes it challenging to extract the data into a typical tabular form. This blog post will explore using the "Key Value Pivot" Output type found in our JSON Source/Extract Components to parse Key/Value pairs from JSON documents with ease.


Using Premium Hash for Efficient and Easy Change Tracking in SSIS

28 August 2020
Chen Huang

It is always crucial for an ETL process to have a change tracking mechanism to identify when a change has happened to any set of data and only process data that has changed. Let's show you how to implement change tracking with our Premium Hash component.

comments powered by Disqus