Trying using Google sheet as a source in SSIS to SQL server destinaton but failed

See more:

SSIS

google-api

beyondrelational.com[^] I tried this link and created a package to extract data from Google Spreadsheet but failed due to this error.(

<pre lang="C#">&lt;pre lang=&quot;C#&quot;&gt;&amp;lt;pre lang=&amp;quot;C#&amp;quot;&amp;gt;at Google.GData.Client.Utilities.getAuthException(TokenCollection tokens, HttpWebResponse response)
   at Google.GData.Client.Utilities.QueryClientLoginToken(GDataCredentials gc, String serviceName, String applicationName, Boolean fUseKeepAlive, IWebProxy proxyServer, Uri clientLoginHandler)
   at Google.GData.Client.GDataGAuthRequest.QueryAuthToken(GDataCredentials gc)
   at Google.GData.Client.GDataGAuthRequest.EnsureCredentials()
   at Google.GData.Client.GDataRequest.EnsureWebRequest()
   at Google.GData.Client.GDataGAuthRequest.EnsureWebRequest()
   at Google.GData.Client.GDataRequest.Execute()
   at Google.GData.Client.GDataGAuthRequest.Execute(Int32 retryCounter)
   at Google.GData.Client.Service.Query(Uri queryUri, DateTime ifModifiedSince, String etag, Int64&amp;amp;amp; contentLength)
   at Google.GData.Client.Service.Query(FeedQuery feedQuery)
   at Google.GData.Spreadsheets.SpreadsheetsService.Query(WorksheetQuery feedQuery)
   at SC_1f7114dc16da4933a6546f830b29340e.vbproj.ScriptMain.PreExecute()
   at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.PreExecute()&amp;lt;/pre&amp;gt;&lt;/pre&gt;</pre>

)

What I have tried:

<pre lang="C#">&lt;pre lang=&quot;C#&quot;&gt;at Google.GData.Client.Utilities.getAuthException(TokenCollection tokens, HttpWebResponse response)
   at Google.GData.Client.Utilities.QueryClientLoginToken(GDataCredentials gc, String serviceName, String applicationName, Boolean fUseKeepAlive, IWebProxy proxyServer, Uri clientLoginHandler)
   at Google.GData.Client.GDataGAuthRequest.QueryAuthToken(GDataCredentials gc)
   at Google.GData.Client.GDataGAuthRequest.EnsureCredentials()
   at Google.GData.Client.GDataRequest.EnsureWebRequest()
   at Google.GData.Client.GDataGAuthRequest.EnsureWebRequest()
   at Google.GData.Client.GDataRequest.Execute()
   at Google.GData.Client.GDataGAuthRequest.Execute(Int32 retryCounter)
   at Google.GData.Client.Service.Query(Uri queryUri, DateTime ifModifiedSince, String etag, Int64&amp;amp; contentLength)
   at Google.GData.Client.Service.Query(FeedQuery feedQuery)
   at Google.GData.Spreadsheets.SpreadsheetsService.Query(WorksheetQuery feedQuery)
   at SC_1f7114dc16da4933a6546f830b29340e.vbproj.ScriptMain.PreExecute()
   at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.PreExecute()&lt;/pre&gt;</pre>