Skip to content

Latest commit

 

History

History
54 lines (38 loc) · 3.08 KB

import-column-transformation.md

File metadata and controls

54 lines (38 loc) · 3.08 KB
Raw
title description author ms.author ms.date ms.service ms.subservice ms.topic f1_keywords helpviewer_keywords
Import Column Transformation
Import Column Transformation
chugugrace
chugu
03/01/2017
sql
integration-services
conceptual
sql13.dts.designer.importcolumntrans.f1
Import Column transformation [Integration Services]
columns [Integration Services], importing
importing data, SSIS packages
inserting data

Import Column Transformation

[!INCLUDEsqlserver-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.

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).

    [!NOTE]
    A BOM is only expected if the data has the DT_NTEXT data type.

A column in the transformation input contains the names of files that hold the data. Each row in the dataset can specify a different file. When the Import Column transformation processes a row, it reads the file name, opens the corresponding file in the file system, and loads the file content into an output column. The data type of the output column must be DT_TEXT, DT_NTEXT, or DT_IMAGE. For more information, see Integration Services Data Types.

This transformation has one input, one output, and one error output.

Configuration of the Import Column Transformation

You can set properties through [!INCLUDEssIS] Designer or programmatically.

The Advanced Editor dialog box reflects the properties that can be set programmatically. For more information about the properties that you can set in the Advanced Editor dialog box or programmatically, click one of the following topics:

Related Tasks

For information about how to set properties of this component, see Set the Properties of a Data Flow Component.

See Also

Export Column Transformation
Data Flow
Integration Services Transformations