SQL Server Integration Services (SSIS) Tutorial - SQL Server Integration Services (SSIS) Part 11 - Looping Over Files

If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching! By Andy Brown https://www.wiseowl.co.uk - You can use FOREACH containers to loop over all of the files in a folder (including, optionally, to include all of the files in this folder's subfolders also). This tutorial shows how to add the names of all of the files in a folder structure into a SQL Server table, and how to use an expression constraint to copy the text files to a separate location. If you like the style of our tutorials but think that there is no substitute for classroom training, we agree with you! Have a look at our two-day SSIS introductory course at https://www.wiseowl.co.uk/courses/ssis.htm (the course runs in the UK, and in warm countries by arrangement).