The best approach for this is to leave SharePoint as it is. There are good reasons for SharePoint being set up to not save files to a directory.
If you want to access the files in SSIS then use a script task and download the file from the SharePoint site to a local directory. Process as normal and then delete the local file.
There are plenty of examples online on how to download from SharePoint in code.