I have seen some posts about Bulk attachment export, and I just completed our project doing that. Once I found this solution it took less than a day.
Using BCP (2 different techniques) did not work. But using SSIS worked like a charm.
First step was encoding the attachment file into base 64, and then create an SSIS package to do the conversion
Convert SQL Server Base64 Encoded Text to Images (mssqltips.com)
The only issue I ran into was not being able use the File formatting of the c: drive. If you are not able to you have to find it in the AppData folder for Visual Studio.
Hopefully this helps someone.
