CONFIGURING SSIS FLAT FILE SOURCE

A Flat File source is a data flow component that uses metadata defined by a Flat File connection manager.

Add a Flat File source component

1. To open the Data Flow designer, either double-click on the Extract Sample Currency Data data flow task, or select the Data Flow tab.

2. In the SSIS Toolbox, expand OtherSources, and then drag a Flat File Source onto the design surface of the Data Flow tab.

3. On the Data Flow design surface, right-click the newly added Flat File Source, select Rename, and change the name to Extract Sample Currency Data.

4. Double-click the Flat File source to open the Flat File Source Editor dialog.
5. In the Flat file connection manager field, select Sample Flat File Source Data.

6. Select Columns and verify that the names of the columns are correct.

7. Select OK.
8. Right-click the Flat File source and select Properties.

9. In the Properties window, verify that the LocaleID property is set to English (United States).