SSIS||Loading of all CSV and Text Files having same schema in Folder and Sub-Folders into one Table
How to load all text and csv files in the folder into one table?
1. Create Two variable (Folder Path and FileName)
2. Configure For Each File Enumerator and mention Files as . and opt for Fully Qualified..
3. Mapping FileName variable to 0 in Index
4. Write Expression for Directory Property and Evaluate Variable FolderPath.
5. Configure DFT.
6. Select properties of Flat File Connection Manager and write expression for Connection String property and Evaluate FileName Variable.
