Pulling data from Google Analytics into SSIS can be a difficult and time-consuming task. The REST Source in Task Factory allows users to import data to their data flow using Google's Analytics' Rest API.
The video below gives you step-by-step instruction on how to use the REST Source in Task Factory to pull data from your Google Analytics account into your SSIS data flow. We show how to use both Version 3 and Version 4 of the Google Analytics API’s.
For detailed information on how to use Task Factory's REST Source with Google Analytics, please visit the Task Factory Help Documentation: http://help.pragmaticworks.com/TaskFactory/ConfigurationFiles.html