0

I am a frequent SSIS user but not a frequent Script task user.

I am trying to download a bunch of excel files from SharePoint Online(https://company.sharepoint.com/xyz/file1.xlsx), I have a set of office 365 credentials that are to be used for access.

My plan is to download the xlsx files to a local location and then load the data to my SQL server db.

However I was not able to find a script task script that would help me go about this specific task(special emphasis on office 365 credentials).

Any help would be appreciated

Dhananjay Rele
  • 13
  • 1
  • 2
  • 7
  • SSIS has `Connection manager for HTTP Connections`. Did you try that? You'll need domain in additon to username, password. Also, go through : http://www.sqlis.com/sqlis/post/Downloading-a-file-over-HTTP-the-SSIS-way.aspx – Prabhat G Feb 27 '18 at 06:15
  • When I try to create the HTTP connection, I get an error when I test the connection saying "Error 401, connection forbidden" – Dhananjay Rele Feb 27 '18 at 16:00
  • Correction: Error 403 – Dhananjay Rele Feb 27 '18 at 16:43
  • I understand, that's because of restrictions on domain. You'll have to contact admin for correct setting and necessary bypass. – Prabhat G Feb 28 '18 at 05:23
  • 1
    ok, so I figured this one out, the SharePoint Online uses Office365 Authentication, which is not the same as standard login. I had a script task and used SharePoint Online SDK and referenced dlls from the script task. – Dhananjay Rele Mar 02 '18 at 16:27

0 Answers0