Step 5: Adding and Configuring the Flat File Source
Applies To: SQL Server 2016
In this task, you will add and configure a Flat File source to your package. A Flat File source is a data flow component that uses metadata defined by a Flat File connection manager to specify the format and structure of the data to be extracted from the flat file by a transform process. The Flat File source can be configured to extract data from a single flat file by using the file format definition provided by the Flat File connection manager.
For this tutorial, you will configure the Flat File source to use the Sample Flat File Source Data connection manager that you previously created.
Open the Data Flow designer, either by double-clicking the Extract Sample Currency Data data flow task or by clicking the Data Flow tab.
In the SSIS Toolbox, expand OtherSources, and then drag a Flat File Source onto the design surface of the Data Flow tab.
On the Data Flow design surface, right-click the newly added Flat File Source, click Rename, and change the name to Extract Sample Currency Data.
Double-click the Flat File source to open the Flat File Source Editor dialog box.
In the Flat file connection manager box, select Sample Flat File Source Data.
Click Columns and verify that the names of the columns are correct.
Right-click the Flat File source and click Properties.
In the Properties window, verify that the LocaleID property is set to English (United States).