Integrate Google Analytics with SQL Server Using SSIS

19 March 2018
KingswaySoft Team

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 

Announcing Migration Starter Pack v3.0 for Microsoft Dynamics 365 Customer Engagement and CRM On-Premise

13 March 2018
Daniel Cai

Our CRM migration starter pack has been widely used by many clients worldwide. We have just made further enhancements to cover some important migration tasks.


How Better Bathrooms Uses SSIS Productivity Pack to Consume REST APIs in SSIS

08 March 2018
KingswaySoft Team

In our recent case study we spoke with the team from Better Bathrooms to learn more about how they are using SSIS Productivity Pack in their data warehouse process to retrieve data from various REST APIs.


How to Work with RESTful Endpoints in your SSIS ETL Process

27 February 2018
KingswaySoft Team

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.


How to Cope with the new Dynamics 365 API Limits

27 February 2018
Daniel Cai

There was a sudden announcement from Microsoft Dynamics 365 Customer Engagement team about an upcoming API Limits. This blog post discusses the strategies and options for you if you rely on some heavy integration in your organization.


Export data from SQL Server to Excel using SSIS

22 February 2018
KingswaySoft Team

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
KingswaySoft Team

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
KingswaySoft Team

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.


Archive

Tags