SQLBI is a blog dedicated to building Business Intelligence solutions with SQL Server.
You can follow me on Twitter: @marcorus
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…
If you would like to receive an email when updates are made to this post, please register here
Subscribe to this post's comments using
About Marco Russo (SQLBI)
Marco Russo is a consultant, writer and trainer specialized in Business Intelligence with Microsoft technologies. He runs the SQLBI.COM website, which is dedicated to distribute resources useful for BI developers, like Integration Services components, Analysis Services models, tools, technical information and so on. Marco is certified as MCT, MCDBA, MCSD.NET, MCSA, MCSE+I.