October 10, 2016 at 8:01 am
I have a client request to upload an Excel spreadsheet to Google Drive on a monthly basis, which I would like to automate - is this possible from SSIS? I found this Microsoft link -
but this is referring to downloading rather than uploading.
Thanks.
October 10, 2016 at 8:07 am
Wolfmeister (10/10/2016)
I have a client request to upload an Excel spreadsheet to Google Drive on a monthly basis, which I would like to automate - is this possible from SSIS? I found this Microsoft link -but this is referring to downloading rather than uploading.
Thanks.
I suggest that you work out how to do this outside of SSIS first. Maybe do a POC in C#. Once you get that working, you can move your code to SSIS.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
October 10, 2016 at 11:44 am
Google being Google means the preferred method is using their APIs and components. Which means they would need to be installed on the server running the process.
I did find a company selling SSIS - Google Drive connectors so you might want to search for those. I didn't put in a link because I've never used them and they're easily found on a Google search. Go figure.
October 11, 2016 at 5:28 am
Thanks guys.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply