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.


Find and Merge CRM Duplicates With Ease Using SSIS Productivity Pack

04 November 2016
Chen Huang

This blog demonstrates how to use our SSIS Duplicate Detector component to find and merge duplicates with ease in CRM.


Implement BDD functionality using RowIndex function in the SSIS Productivity Pack

02 September 2016
Daniel Cai

SSIS Balanced Data Distributor has been commonly used for distributing incoming rows to multiple SSIS destination components to help improve integration performance. However BDD comes with a few limitations. In this blog post, I will show you a better way to implement it without sacrifice from the those limitations.

comments powered by Disqus