Flat File Source Editor (Connection Manager Page)
Applies To: SQL Server 2016
Use the Connection Manager page of the Flat File Source Editor dialog box to select the connection manager that the Flat File source will use. The Flat File source reads data from a text file, which can be in a delimited, fixed width, or mixed format.
A Flat File source can use one of the following types of connection managers:
A Flat File connection manager if the source is a single flat file. For more information, see Flat File Connection Manager.
A Multiple Flat Files connection manager if the source is multiple flat files and the Data Flow task is inside a loop container, such as the For Loop container. On each loop of the container, the Flat File source loads data from the next file name that the Multiple Flat Files connection manager provides. For more information, see Multiple Flat Files Connection Manager.
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.