Import Column (SSIS)

The Import Column transformation reads data from files and adds the data to columns in a data flow. Using this transformation, a package can add text and images stored in separate files to a data flow. For example, a data flow that loads data into a table that stores product information can include the Import Column transformation to import customer reviews of each product from files and add the reviews to the data flow.
The Import Column Transform is a partner to the Export Column Transform. These transforms do the
work of translating physical files from system file storage paths into database blob - type fields and vice
versa.
You can configure the Import Column transformation in the following ways:

• Specify the columns to which the transformation adds data.
• Specify whether the transformation expects a byte-order mark (BOM).

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