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:

  1. Create a new SSIS package and name it Master Package. Drag-and-drop a Foreach Loop container in Control Flow.
  2. Create a variable with a string type and name it FilePath.
  3. Double-click on the Foreach Loop Container ...

Get Microsoft SQL Server 2014 Business Intelligence Development: Beginner’s Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.