SSIS Tutorial Part 23 - Read Files as per Extension and Load them to a SQL Server Table in SSIS Package

The video explain real time scenario in which we have multiple types of files sitting in a folder and we want to load only specific type of files by using SSIS Package.

In this video you will also learn

  1. How to create an SSIS Package
  2. How to use Foreach Loop Container in SSIS Package
  3. How to read specific type of files by using Foreach Loop Container
  4. How to use Data Flow Task to load flat files into SQL Server Table
  5. How to write expressions in SSIS Package


  1. Why same concept not working for the Excel files. I am getting new excel files every day and I need to dump the data from Excel to SQL Server, I tried so many solutions but all are giving errors for Connection string. I also tried to use the ExcelFilepath instead of Connection String but nothing working

    1. Use excel file path in expression provide the complete excelpath/filename.ext and keep the delay validation true. Once package is scheduled then automatically package will pick the dynamic excel file which is coming daily in your folder and load the data.

      I have tried this and worked in my case.

  2. I did flat file source in SSIS package. But I always failed to go through this.