SSIS Tutorial 27-Extract file Names from Folders and save in SQL Server Table by using SSIS Package

In this video of SQL Server Integration Services(SSIS) Tutorial, you will learn how to extract the file names from folder and sub folders and insert that into a SQL Server Table by using SSIS Package.

In this video we will also learn

  1. How to create an SSIS Package
  2. How to use Foreach Loop Containers to read the files from folders in SSIS Package
  3. How to use Execute SQL Task in SSIS Package
  4. How to pass parameter to Execute SQL Task in SSIS Package