SQL Server Integration Services (SSIS) Tutorial - SQL Server Integration Services (SSIS) Part 12 - Other Foreach Loops

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 - A previous tutorial showed how to loop over files in a folder using SSIS packages; this one shows how to use the other main types of FOREACH loop. The tutorial covers: - looping over rows in a table using an ADO enumerator - looping over items in an in-memory table - looping over the rows of a SQL Server schema recordset - looping over the nodes in an XML file 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).