Time for action – looping through CSV files in a directory and loading them into a database table
In this example, we will use the
Foreach Loop container to loop through files in a directory, and then we will set the connection manager of the source file dynamically in the flat file source, and load the content of the source file into the destination database table. Then, we will write a log entry into the database with the name of the file and load date time. For this example, we use packages and tasks that we developed in the last two examples:
- Create a new SSIS package and name it
Package. Drag-and-drop a Foreach Loop container in Control Flow.
- Create a variable with a string type and name it
- Double-click on the Foreach Loop Container ...