We are trying to connect to an excel file within a Sharepoint folder through oData SSIS connection, but can't seem to connect to the folder. Through a bunch of trial and error and using a query, we were able to pull a list of files and find the file name within that list, but still unable to read into it.
Any ideas on how I can connect to a Sharepoint folder and file through odata with SSIS?
