This article shows how to create a Flat File Connection Manager in SSIS, load its data into the Integration Services, and transform its data.
The below screenshot shows that it is a simple text file, and a Comma separates each column.
SSIS Flat File Connection Manager
Within the Solution Explorer, right-click on the Connection Managers folder and choose New Connection Manager.
Select the FLATFILE option, which helps connect with flat files and read their data. For more Data Loading options >> Click Here.
It opens the SSIS Flat File Connection Manager Editor window. Change the Name and add a description as per your need. Let me click on the Browse button to choose the file. Here, we have chosen the Employee text file.
Format: You must provide how the flat file separates Column values.
- Delimited: Comma, Space, etc.
- Fixed Width: Fixed amount of space for each column.
- Ragged Right: Fixed width.
Text Qualifier: None. Use double quotes if the columns and row values are enclosed in double-quotes.
Use the Column tab to check whether the columns are appropriately separated. If not, change the Row and Column delimiters.
Use the advanced tab to change the Data type of each column as per your requirement.
Now you can see the Flat File Connection Manager. Add data Flow Task and double-click on it.
Add Flat File Source and double-click to choose the Flat File Connection Manager we created earlier.
Check the columns.
Add Copy Column and add a data viewer to see the data. Next, run the SSIS package to view the result.
