Connection Manager for ADO.net connection to my Google Drive for SSIS

Question

I have some dtsx packages I've created at home in VS 2017, the SSIS component. They pull some rather large datasets from an MS Access source to Sql Server. I do this sort of thing at work too. But I'd like to showcase my work on my google drive. I've uploaded at least one package of a fictional dataset of engineering data.

I'd like it to be available to prospective new employers and recruiters seeking data analysts, specifically database analysts.

However, I'm not ready to pay the prices I find at places like Cdata! Can I create a connection manager to my google drive for free?

Answer 1

Hi @Robleh Wais

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 may try with script task in SSIS.

Also check it out here: http://www.statslice.com/leveraging-google-docs-with-ssis

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.