Setting KingswaySoft Component Properties Dynamically

14 January 2020
Aswin Manmadhan

Parameterizing a component has many advantages over hardcoding the value. In this blog, we will see how parametrization can be done easily in KingswaySoft components.

 REST   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.


Simplify SSIS Lookup Development

25 September 2018
Jessica Petta

Performing lookups in SSIS can quickly lead to rather intricate data flow designs when developer's need to perform multiple lookups with various conditions. With Premium ADO.NET Destination lookup feature, development becomes much easier with a much simpler data flow to maintain saving significant development time now and in the future.

 SSIS 

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 Different OAuth 2.0 Grants in SSIS

01 June 2018
Jeremy Ji

In this blog post we discuss how to work with OAuth 2.0 Password and Client Credentials grant types when working with web service endpoints in SSIS.

 REST   SSIS 

Integrate Google Analytics with SQL Server Using SSIS

19 March 2018
Jessica Petta

Looking to reduce the time spent creating our monthly Google Analytics reports, in this blog post we outline the steps we took to automate our Google Analytics to SQL Server integration using SSIS Productivity Pack.

 SSIS 

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.


Export data from SQL Server to Excel using SSIS

22 February 2018
Jessica Petta

In this blog post we will cover how you can take advantage of the SSIS Productivity Pack to easily export data from SQL Server to Excel using SSIS.

 SSIS 
comments powered by Disqus