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.

Using OAuth 2.0 Authorization with a Certificate in SSIS

10 December 2019
Chen Huang

We explore the JWT assertion OAuth2 authentication process with a certificate and demonstrate the process of working with an OAuth2 authentication workflow in SSIS

Parameterizing CDS/CRM Connection Manager

14 November 2019
Mohamed Abdalkarim

Parametrize your CDS/CRM Connection Manager to execute the same SSIS package deployed to your SSISDB catalogue to integrate different CDS/CRM instances. Learn how.

Extracting Audit Logs for Multiple CRM Entities

16 October 2019
Aswin Manmadhan

KingswaySoft SSIS Integration Toolkit for Dynamics 365 offers a robust and easy way to retrieve and read audit logs. Learn how to extract these audit logs.

Using BIML with KingswaySoft SSIS Components

21 December 2018
Mohamed Abdalkarim

BIML can be used to automate the generation of multiple SSIS packages. In this blog post we will show you how you can utilize BIML when working with SSIS Integration Toolkit or SSIS Productivity Pack components.

Using SSIS to Mask Data to Assist with GDPR Compliance

27 June 2018
Jessica Petta

SSIS can be a useful tool in assisting with GDPR compliance. In this blog post we will demonstrate how to use SSIS to mask information in an environment so that the data structure remains intact but no sensitive information is stored on the environment.

How to Work with RESTful Endpoints in your SSIS ETL Process

27 February 2018
Jeremy Ji

Connecting to an integrating with a REST API in SSIS can be a tricky process. In this blog post we will walk you through how our SSIS Productivity Pack can be used to simplify the development process. We will be working with ZenDesk as an example to demonstrate integration with a REST API feeding data in JSON format.

Incremental Load in SSIS with Diff Detector

29 January 2018
Jessica Petta

Easily develop incremental load in SSIS within one data flow by utilizing SSIS Productivity Pack. In this blog post we will cover how you can use Diff Detector and Premium ADO.NET Source & Destination to quickly create performant incremental loads in SSIS.

comments powered by Disqus