SSIS | Foreach Loop
#ssis
0 In the Control Flow pane, create a foreach container
1 In the Control Flow pane, inside the foreach container, create a data flow task
2 In the Control Flow pane, create flat file connection, check data types
3 In the Control Flow pane, create an ole db destination
4 Create a variable
5 Double click on the data flow task
6 Go into data flow pane
7 Create a flat file source
8 Connect the created flat file source with the step 2
9 Create an ole db destination
10 Connect Flat file source with old db destination
11 Connect the created ole db destination with the step 3
12 Check Mappings
13 Go back to control flow
14 Edit the foreach loop Collection Enumerator and change to Foreach File Enumarator, set the folder, set the file extension, add variable
15 On the connection manager small pane, edit the flat file connection manager, in expressions, add a connectionstring and set to the filepath variable
16 Run the project
17 Go back to Control Flow
18 Bonus part, add an Execute SQL task to delete duplicates based on two columns