Is it Sharepoint or Sharepoint Online connection?
Is it downloading the files to the path mentioned in the sharepoint connection, 'Attachment File Path' ?
I'm using Sahrepoint Online connector.
Yes it is downloading the files to the Attachment file path.
You can use the workaround below by breaking the tasks since s3 is not supported in Synch tasks as target.
->Create a synch task to load the files locally
->Use flat file connector as source and S3 as target in a mapping to upload them in required buckets.
Below are the guides for reference .
Hope this will help .