Read from excelm in SharePoint

• PSB

  SSChampion

  Points: 13195

  More actions

  October 9, 2017 at 5:29 am

  #333148

  Hi,

   How can I read from an excel file that is located in SharePoint using SSIS ? Below is how the link looks like in SharePoint ,

  https://test001.sharepoint.com/sites/Folders/Subfolder/_layouts/15/WopiFrame.aspx?sourcedoc=%7B799F61DB-8325-4F5D-B29A-50CA44F5815D%7D&file=ExecutiveSummary%20-%20F2.2.xlsx&action=default

  Thanks,
  PSB

• sgmunson

  SSC Guru

  Points: 110644

  More actions

  October 9, 2017 at 7:36 am

  #1962822

  First, that file location has to have permissions set so that the execution context of your SSIS package has access to that path.   Then you just specify the path.   If that path has any part of itself that is based on a specific user, then it probably won't work.  It would have to be a path that any user that has access to that folder could use to get there using their browser.

  Steve (aka sgmunson)
  Rent Servers for Income (picks and shovels strategy)