ssis Load multiple CSV files of same format from a folder


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


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