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.