title: Download files from Sharepoint 365 using SSIS
body: <p>I have a document library (Sharepoint 365) named "S &amp; P" which contains many folders &amp; sub-folders. My requirement is to download all the files exists in these folders/sub-folders to my local/server folder by using SSIS package. This can be done by either using a script task (C# or VB code) or execute process task(Powershell or Batch script) but I am not able to pull any file. So far I have tried to use powershell - failed &amp; C# code - failed. All the code used was copied from internet (don't know much of C# &amp; Powershell).</p>
  
  <p>Any solution to retrieve these files from sharepoint to my local folder would be accepted (can't use 3rd party or unauthorized tools)</p>
  
  <p>SharePoint URL structure is like below- <a href="https://xyzcompany.sharepoint.com/sites/dm/S%20%20P/Forms/AllItems.aspx" rel="nofollow noreferrer">https://xyzcompany.sharepoint.com/sites/dm/S%20%20P/Forms/AllItems.aspx</a></p>
  
  <p><strong>Note: All folders &amp; subfolder are in S &amp; P document library</strong></p>
  
  <p>Please help! </p>