I am trying to use the Excel Source ... and into the OLE DB Connection Manager (click new)
For the Excel file path I put in the https path from Share Point (teams.radac.com/sites/IT/test.xls)
When I click OK.. and then try and select the "Name of Excel Sheet" it just gives an error loading file.
If I download the file, from sharepoint, and then point SSIS to the drive location.. it is fine.
How do I get SSIS to pull a file off share point??