Attachment Export

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 (

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.

Parents Reply Children
No Data