I really don’t like to use the blog as an advertising tool, but sometimes I feel the need to mention third party products because I thing they are interesting enough.

Today I discovered that CozyRoc implemented the Parallel Loop Task in SSIS. This is a feature I requested more than 3 years ago on Connect and today it is available. Well, not for free, but in a library which contain several interesting tools (including the TableDifference and FlowSync components originally developed by Alberto Ferrari).

Why you should use the Parallel Loop Task? Well, just imagine you have to process many files in a directory, loading them in SQL Server. You have to enumerate them and to process them. Without the Parallel Loop Task it is really hard to leverage the parallelism in SSIS. If only we had that component three years ago…

Originally appeared on: http://sqlblog.com/blogs/marco_russo/archive/2010/08/06/the-parallel-loop-task-in-ssis.aspx