Export Column (SSIS)

The Export Column transformation reads data in a data flow and inserts the data into a file.
For example, if the data flow contains product information, such as a picture of each product, you could use the Export Column transformation to save the images to files.
Unlike the other transformations, the Export Column Transform doesn ’ t need a destination to create the
file. 

You can configure the Export Column transformation in the following ways:

• Specify the data columns and the columns that contain the path of files to which to write the data.
• Specify whether the data-insertion operation appends or truncates existing files.
• Specify whether a byte-order mark (BOM) is written to the file.

http://msdn.microsoft.com/en-us/library/ms139818.aspx