• Please refer to the following similar thread, you may find the answer there:

    https://social.msdn.microsoft.com/Forums/sqlserver/en-US/8afed667-4b3b-4a1b-8c81-f2d039e974bb/use-ssis-to-read-files-in-sharepoint-library?forum=sqlintegrationservices

    Hope this helps!:-)