Connect SSIS to Google Drive or Google Sheets

Question

Hello,

I need to download a file from google Drive or open it, using SSIS but I have not found any reference about it. Is it possible?

Is there a provider to connect to Google Drive. Can anyone help me?

Thanks,

Andrés

Answer 1

Power Pivot is the solution.

https://social.technet.microsoft.com/Forums/sqlserver/en-US/7a707be9-57c3-4e09-9a38-14e709a909cb/connect-to-google-calendar-and-speedsheet?forum=powerquery

---

Regards, RSingh

Answer 2

Hi ,

 Google Drive have their own programming interface, so if you want to be able to connect to any one of them, you need to code to all three API's.

Here is some reference material:

Google Drive Web API's

You should try with script task in ssis 

---

Please Dont forget to mark as answer. It helps others to find relevant posts to the same question. Milan Das

Answer 3

Hi Andrés,

According to your description, you want to connect to Google Drive or Google Sheets in SSIS.

Based on my research, to connect and interact with Google Spreadsheet data, we need download and install Google Data API SDK. Then add Google API DLLs into Global Assembly Cache (GAC).

After completing the two pre-requisite, you are all set to start with Google Spreadsheet and SSIS. For more details, please refer to the following two blogs:
http://beyondrelational.com/modules/24/syndicated/398/Posts/15475/ssis-how-to-load-data-into-sql-table-from-google-spreadsheets.aspx
http://www.statslice.com/leveraging-google-docs-with-ssis

Thanks,
Katherine Xiong

---

Katherine Xiong
TechNet Community Support

Answer 4

Don't bother. It'll be clunky and take far too much time. At best, use the API in Python/Pandas, download the document into Excel, then maybe use SSIS if you must. It'd be far easier to use Pandas for the entire end to end integration.

Answer 5

You may want to check the commercial COZYROC SSIS+ library. It includes connectors for both Google Drive and Google Sheets.

---

SSIS Tasks Components Scripts Services | http://wwww.cozyroc.com/