Flat File Source Editor (Connection Manager Page)
Use the Connection Manager page of the Flat File Source Editor dialog box to select the flat file connection manager for the source to use. The flat file source reads data from a text file, which can be in a delimited, fixed width, or mixed format.
To learn more about the Flat File source, see Flat File Source.
- Flat file connection manager
Select an existing connection manager from the list, or create a new connection manager by clicking New.
Create a new connection manager by using the Flat File Connection Manager Editor dialog box.
- Retain null values from the source as null values in the data flow
Specify whether to keep null values when data is extracted. The default value of this property is false. When this value is false, the Flat File source replaces null values from the source data with appropriate default values for each column, such as empty strings for string columns and zero for numeric columns.
Preview results by using the Data View dialog box. Preview can display up to 200 rows.