Hello anthony,
Here , I would like to answer about the query, I have already worked with Google Analytics import to SQL via SSIS . We have a specific resource of this , Where You will get the proper guide of work. To know more about this , Please follow this link
More about SSIS Google Analytics
Hope It will be helpful.
🙂