HOIT ASIA -Sever Free Download

Case I have a Foreach Loop Container with a file enumerator. The wildcard is *.xls, but it also returns *.xlsx files. How do I prevent that?  Loop t…

Case I want to continue my loop when in one of the iterations a task fails. It should continue with the next iteration/file. I tried changing the tas…

Case I have a list of files in a database table which I want to loop through. Can I use a Foreach Loop Container for that? My table with files Soluti…

Case I want log all my connection managers, delete all my excel files, check whether my flat files exists. And I don't want to add task for all o…

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…

Case When the Foreach Loop File Enumerator is empty, SSIS will throw a warning, but I want to fail the package. How do I do that? The For Each File e…

In some cases the standard wildcard filter in the Foreach File Enumerator isn't flexible enough. Try to get all files ending with a number or all…

Case The standard Foreach Loop File Enumerator only has a wildcard filter, but in some cases a regular expression filter would be more useful. See/v…

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…

Case I want to loop through all files in a FTP folder and process them. I need a Foreach ftp file enumerator, but the Foreach Loop component only loo…