ssis Load multiple CSV files of same format from a folder

Help us to keep this website almost Ad Free! It takes only 10 seconds of your time:
> Step 1: Go view our video on YouTube: EF Core Bulk Extensions
> Step 2: And Like the video. BONUS: You can also share it!

Introduction

In this guide you can find out steps to load multiple CSV/TXT files from a folder to the database table.

Parameters

Parameter/VaiableDetails
SourceFolderIt is a read only project parameter available and configurable at the deployment. Example of project parameter are Connection Strings, passwords, port no, users etc
CompleteSourceFilePathIt is read write user variable available only inside the package like local variables in programming languages


Got any ssis Question?