Read and Load Data Files Iteratively from a Storage Location

13 April 2022
KingswaySoft Team

There are cases where we would need to retrieve a set of files from a storage location, which are dropped on the same day, and read them one by one, to then store them into a database table. We can easily achieve this using KingswaySoft components and the SSIS Foreach loop container.


Executing Snowflake Functions in SSIS ETL Processes

28 March 2022
KingswaySoft Team

The Snowflake command task that is a control flow level task can be used to easily execute functions in Snowflake and use it for further data flow executions


Convert Word documents to PDF Leveraging Google Drive Platform

28 February 2022
KingswaySoft Team

It is a very common business requirement that in our job we may receive documents in some particular formats, which the business team would like to have them converted into PDF files. Such requirements arise from many of the advantages when using PDF formats for file exchanges, such as portability, universal compatibility, reliability, security, size reduction, versatility, professionalism, etc. Given such common requirement, it would be highly useful to have a tool that can pick up documents from a specific location and have them converted to a PDF files in an automated manner, such as an automated ETL process. In this blog post, we will show you how to easily achieve this using components from our SSIS Productivity Pack product offering.


Working with Business Central/NAV REST API v2 in SSIS

27 January 2022
KingswaySoft Team

This post will walk through how to query the Dynamics Business Central/NAV REST API data using the Premium OData Source component.


Working with Microsoft Graph API in SSIS using KingswaySoft Productivity Pack

26 January 2022
KingswaySoft Team

This blog post demonstrates how to use the Premium OData Source component to work with SharePoint site data through Microsoft Graph REST API.


Perform Lookups When your Target Values are Padded

22 December 2021
KingswaySoft Team

In our ETL development, we don't always receive the data in the exact format that we expect it to be. For instance, there might be cases that the incoming data is a string value while we expect an integer, or in some other cases, there might be unexpected whitespaces which can make the lookup difficult. This blog post will specifically cover the lookup scenario and show you how to achieve the lookup functionality without additional extra work.


Extracting RSS Feed Data in ETL Process using KingswaySoft

26 October 2021
KingswaySoft Team

It’s a very common practice to receive news updates using RSS feeds. Even though users are shifting to social media for getting news and headlines that are prominent, these platforms are controlled by algorithms that decide what news goes to which user, and users may see the headlines which the platform decides. RSS feeds provide all the contents that are published by the sources that can be subscribed to. Now, when it comes to integration, extracting RSS feeds data can be a challenging task without a proper tool. In our blog post here today, we will show how you could leverage KingswaySoft SSIS Productivity Pack to achieve this with ease, so that you could possibly consume the data in your ETL process with great control.


Incremental Read of Email Messages when Working with POP3 Connections

28 September 2021
KingswaySoft Team

KingswaySoft provides Email Source component in our SSIS Productivity Pack product which can be used to read email messages from your mailboxes. And this component supports EWS, IMAP and POP3 protocols, it can be used to read emails from various email systems, including Microsoft Office 365, Exchange Server, Gmail, and almost all other major email services. It is fairly easy to read messages when working with EWS and IMAP protocols. However it is not very straightforward to achieve so when working with the POP3 connections. In blog post, we will show you how we can achieve such incremental reading using POP3 connections.


Archive

Tags