Flat File Source in SSIS

A Flat File Source in SSIS is used to extract or reads data from text files. Flat File Source uses Flat File Connection Manger to connect with the text files.

Configuring Flat File Source in SSIS

In this article we will show you, How to configure Flat File Source in the SQL Server Integration Services to extract data from Text Files.

Drag and drop the data flow task from the toolbox to control flow and change the name as Configuring Flat File Source in SSIS 2014.

Double click on it will open data flow tab. Now, Drag and drop Flat File Source from SSIS toolbox into the data flow region

Double click on Flat File Source in the data flow region will open the Flat File Source Editor to configure the connection manager settings. If you haven’t created Flat File Connection Manger before click on the New button and configure it.

Retain null values from the source as null values in the data flow: If you check mark this option then, it will retain the Null values as Nulls. IF you uncheck the option then, Null values from the source will be replaced with the default values or empty.

In this example we are selecting the already created Connection Manager.

From the above screenshot you can observe that we selected the already created connection manager. Click on the preview button to see the data present in the text file

Click on columns tab to verify the columns. We can also remove the unwanted columns by uncheck them.

Click ok to finish configuring Flat File Source in SQL Server Integration Services.

Thank You for Visiting Our Blog