SSIS Tutorial Part 120-Load Files from Specific Folder Paths Saved in SQL Table By SSIS Package

SSIS Tutorial Scenario:

We have multiple folders inside our main folder but for our SSIS Package we want to load only files from some specific folders which are assigned to that SSIS Package. The folder paths are saved with SSIS Package Name in a Table. We want to Extract the Folder Paths and then load the files to a SQL Server Table in SSIS Package.

What you will learn in this SSIS Package

How to create a Table to store Folder Path and SSIS Package Name
How to Extract Required records (Folder Paths) in SSIS Package from a SQL Server Table by using Execute SQL Task
Why to use Full Result Set in Execute SQL Task in SSIS Package
How to Loop through Object Type variable by using For-each Loop Container and save value to variable
Use nested For-each Loop to use the Folder path that was returned by outer For-each Loop Container.
How to use Variable value in Flat File Connection Manager by using Expressions
How to Archive Files after loading to SQL Server Table in SSIS Package

Blog post link for the video with scripts

Check out step by Step SQL Server Integration Services(SSIS) Tutorial by TechBrothers

[zealbehappy]

i have file location path store in sql and i want move only store path file from particular folder. How i do by ssis ?

[vaishalishinde]

Sir aap ne step first main joh path mention kiya data table main vah pe muje server ka path mention karna toh kasa karna ho ga.
Mera sab folder server pe hai.

Please suggest me

[feng]

if I do not move files into an Archive folder, why the loop will go through twice (means the file will insert into table twice)

[rajkumaragarwal]

do you have any video on incremental loading