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…
Showing posts with the label FOREACH LOOP
Continue Loop after error - Part I
byHOIT
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
byHOIT
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
byHOIT
Case I want log all my connection managers, delete all my excel files, check whether my flat files …
Foreach Excel Worksheet Enumerator
byHOIT
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
byHOIT
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
byHOIT
In some cases the standard wildcard filter in the Foreach File Enumerator isn't flexible enough…
Regex filter for Foreach Loop
byHOIT
Case The standard Foreach Loop File Enumerator only has a wildcard filter, but in some cases a reg…
Custom SSIS Component: Foreach Folder Enumerator
byHOIT
About a year ago I did a post on creating a Foreach Folder Enumerator with a Script Task . Foreach …