Create your own custom Foreach Loop Enumerator
Case I want to create my own custom SSIS enumerator with a GUI. How do you do that? Solution For this example I will create a very basic enumerator w…
Search Suggest
ENUMERATOR
ENUMERATOR
Custom SSIS Component: Foreach Excel Worksheet Enumerator
Recently I did a post on how to loop through all sheets in an Excel file. For those who don't like scripting and for those who think the Foreach…
Foreach Excel Worksheet Enumerator
Case I have an Excel file with multiple identical worksheets (one foreach month) and I want to add the data to a single database table. Is there a fo…
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 Folder Enumerator with Script Task Now I have crea…
Custom SSIS Component: Foreach Sorted File Enumerator
Last year I did a post on how to create a Foreach Sorted File 'Enumerator' with a Foreach ADO Enumerator and a preceding Script Task that cr…
Custom SSIS Component: Foreach FTP File Enumerator
A while ago I did a post on how to create a Foreach FTP File 'Enumerator' with a Script Task and a Foreach Variable Enumerator. Foreach FTP …
Foreach folder enumerator
Case I want a Foreach Folder Enumerator, but the Foreach Loop component only loops through files. Solution Unfortunately this isn't supported by …