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 

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.


Incremental Load in SSIS Made Easy

25 January 2018
Jessica Petta

In this blog post we will cover how you can use SSIS Productivity Pack to quickly develop SSIS incremental load packages within one data flow without needing to perform any lookups.


Update CRM Entityimage in 3 Easy Steps Using Premium Derived Column

24 November 2016
Jeremy Ji

In this blog post we will cover how you can very easily update CRM Entityimage within SSIS using the new Premium Derived Column.

comments powered by Disqus