TechNet
Export (0) Print
Expand All

Export Column Transformation Editor (Columns Page)

 

Applies To: SQL Server 2016

Use the Columns page of the Export Column Transformation Editor dialog box to specify columns in the data flow to extract to files. You can specify whether the Export Column transformation appends data to a file or overwrites an existing file.

To learn more about the Export Column transformation, see Export Column Transformation.

Extract Column
Select from the list of input columns that contain text or image data. All rows should have definitions for Extract Column and File Path Column.

File Path Column
Select from the list of input columns that contain file paths and file names. All rows should have definitions for Extract Column and File Path Column.

Allow Append
Specify whether the transformation appends data to existing files. The default is false.

Force Truncate
Specify whether the transformation deletes the contents of existing files before writing data. The default is false.

Write BOM
Specify whether to write a byte-order mark (BOM) to the file. A BOM is only written if the data has the DT_NTEXT or DT_WSTR data type and is not appended to an existing data file.

Integration Services Error and Message Reference
Export Column Transformation Editor (Error Output Page)

Community Additions

ADD
Show:
© 2016 Microsoft