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

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.

image

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

image

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

image

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!

Advertisements

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

  1. Anthony Coleman June 30, 2014 / 5:59 pm

    haha…Nice post!

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s