Showing posts with the label FOREACH LOOP

Foreach loop with *.xls wildcard also returns *.xlsx files

Case I have a Foreach Loop Container with a file enumerator. The wildcard is *.xls, but it also ret…

Continue Loop after error - Part I

Case I want to continue my loop when in one of the iterations a task fails. It should continue with…

How to configure a Foreach Loop Container: ADO Enumerator

Case I have a list of files in a database table which I want to loop through. Can I use a Foreach L…

Loop through all connection managers

Case I want log all my connection managers, delete all my excel files, check whether my flat files …

Foreach Excel Worksheet Enumerator

Case I have an Excel file with multiple identical worksheets (one foreach month) and I want to add …

Stop package when foreach loop does not find any files

Case When the Foreach Loop File Enumerator is empty, SSIS will throw a warning, but I want to fail …

Custom SSIS Component: Foreach File Enumerator with regex

In some cases the standard wildcard filter in the Foreach File Enumerator isn't flexible enough…

Regex filter for Foreach Loop

Case The standard Foreach Loop File Enumerator only has a wildcard filter, but in some cases a reg…

Custom SSIS Component: Foreach Folder Enumerator

About a year ago I did a post on creating a Foreach Folder Enumerator with a Script Task . Foreach …

Load More That is All