Flat File Custom Properties

Applies to: SQL Server SSIS Integration Runtime in Azure Data Factory

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 name Data Type Description
FileNameColumnName String The 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.
RetainNulls Boolean A 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 name Data Type Description
FastParse Boolean A 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 name Data Type Description
Header String A 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.
Overwrite Boolean A 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.
EscapeQualifier Boolean When text qualifier is enabled, specifies whether the text qualifier in the data written to the destination file will be escaped or not. The default value of this property is False

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

For more information, see Flat File Destination.

See Also

Common Properties