Introduction In our previous article, we saw step-by-step approach to read data from workday using SSIS. In this article, we will focus on how to load SQL Server data to Workday (e.g. POST, Create, Update). We will use SSIS Web API Destination and the combination of other Transforms such as SSIS Template Transform and SSIS XML Generator […]
Introduction In this post, we will learn how to call Zuora API using SSIS. We will go through steps to read data from Zuora and load into SQL Server using SSIS REST API Task and SSIS JSON Source . At the end of this article, you will find a complete sample (dtsx file). Tasks/Components in SSIS for […]
Introduction In this post we will see how to download file from URL using SSIS REST API Task. If you want to call REST API rather than download file then check this article. Basically you can download file from URL using two different tasks. SSIS Download File Task offers simple way to download file without […]
Introduction Custom Dimensions and Metrics pretty powerful feature in Google Analytics. In this post we will learn how you can use them in SSIS Google Analytics Source Find Dimension ID or Metric ID SSIS Google Analytics Source dimension / metric browser doesn’t list custom Dimensions or Custom Metrics so you have to do few extra steps. […]
Introduction In this post we will learn how to use ZappySys SSIS XML Source or ZappySys SSIS JSON Source to read large XML or JSON File (Process 3 Million rows in 3 minutes – 1.2 GB file). If you use default settings to read data then it may result into OutOfMemory Exception so we will outline […]