How to Export Images from a database to file system in SSIS using the Export Column component.

Posted by

I have wanted to blog about this for quite some time. The Export Column is one of those SSIS components that you never use but need to know about just in case. This is also a very easy component to configure.

  1. The source query requires the photo column and the path of where you want to store the photo on your file system.


  1. Next bring the Export Column transform into your data flow and connect it to your source.


  1. Finally, open the export column and set the properties for the Extract Column(Photo) and File Path Column.


Execute the package and you’re done! This transform saved me some time ago when I needed to extract images for a report. Thanks for looking!

One comment

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s