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