ssisLoad multiple CSV files of same format from a folder


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