Loading the data from Google Sheet into SQL Server by using SSIS Package. RRS feed

  • Question

  • Hi Everyone,

               I am facing some problem while  loading the Google sheet data into SQL Server by using SSIS. I have downloaded and installed Google Data API SDK  in my local machine. Script task throwing following error while executing the SSIS package.

    execution of request failed: http://spreadsheets.google.com/feeds/spreadsheets/private/full

     Or is there any way to download the Google sheet data into CSV format in a specified folder/path automatically ?

    Can one help me out on this.

    • Edited by TWoW2017 Friday, August 19, 2016 1:45 PM
    Friday, August 19, 2016 1:44 PM


  • Don't look like a SSIS issue on a first view, better ask this in a Google API forum.

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    • Edited by Olaf HelperMVP Friday, August 19, 2016 7:58 PM
    • Proposed as answer by Seif Wang Tuesday, August 23, 2016 4:04 AM
    • Marked as answer by Eric__Zhang Sunday, September 4, 2016 11:02 AM
    Friday, August 19, 2016 7:57 PM