TechNet
Export (0) Print
Expand All

Flat File Custom Properties

 

Applies To: SQL Server 2016

Source Custom Properties

The Flat File source has both custom properties and the properties common to all data flow components.

The following table describes the custom properties of the Flat File source. All properties are read/write.

Property nameData TypeDescription
FileNameColumnNameStringThe name of an output column that contains the file name. If no name is specified, no output column containing the file name will be generated.

Note: This property is not available in the Flat File Source Editor, but can be set by using the Advanced Editor.
RetainNullsBooleanA value that specifies whether to retain Null values from the source file as Null values when the data is processed by the Data Transformation Pipeline engine. The default value of this property is False.

The output of the Flat File source has no custom properties.

The following table describes the custom properties of the output columns of the Flat File source. All properties are read/write.

Property nameData TypeDescription
FastParseBooleanA value that indicates whether the column uses the quicker, but locale-insensitive, fast parsing routines that DTS provides or the locale-sensitive standard parsing routines. For more information, see Fast Parse and Standard Parse. The default value of this property is False.

Note: This property is not available in the Flat File Source Editor, but can be set by using the Advanced Editor.

For more information, see Flat File Source.

Destination Custom Properties

The Flat File destination has both custom properties and the properties common to all data flow components.

The following table describes the custom properties of the Flat File destination. All properties are read/write.

Property nameData TypeDescription
HeaderStringA block of text that is inserted in the file before any data is written.

The value of this property can be specified by using a property expression.
OverwriteBooleanA value that specifies whether to overwrite or append to an existing destination file that has the same name. The default value of this property is True.

The input and the input columns of the Flat File destination have no custom properties.

For more information, see Flat File Destination.

Common Properties

Community Additions

ADD
Show:
© 2016 Microsoft