Importing excel file from SharePoint using SSIS

Hello everyone

I feel like I've looked at every web page vaguely related to this but can't find the answer. Maybe there isn't one but hopefully someone can help...

I'm using SSIS to import a file from excel into a SQL table. It works fine. What I want to be able to do though is have the same file stored in a SharePoint folder then have the SSIS package pick the file up from there. I've tried using the UNC path but it doesn't work. I feel like the issue is that I need to put my SharePoint credentials in somewhere but can't see where to do this.

Due to our frankly odd setup I'll only need to run this manually from within BIDS/Visual Studio so don't need to worry about what credentials the server might use.

Any ideas gratefully received!