Tag Archives: ForEachLoop Container

Compress Dynamic Files Using 7-Zip in SSIS

Abstract This blog post is in response to a request/comment from Thato in this previous article. Hence, I have taken much of the logic used in the aforementioned article and changed it from static to dynamic file compression. Thus, I am still using SQL Server Integration Services‘s Execute Process Task to compress dynamic files into… Read More »

Programmatically Create Data Flow Task inside a ForEachLoop Container Using C#

Abstract This article explains how to create an SSIS package with a Data Flow Task inside a ForEachLoop Container using C# programming language. Requirements Microsoft Visual Studio 2008 SQL Server 2008 AdventureWorks2008R2 database (downloadable database file available here) Article If the above requirements are all met, we will begin by launching Microsoft Visual Studio 2008.… Read More »

Create SSIS Package with SQL Tasks inside a ForEachLoop Container using C#

Abstract This article explains how to create an SSIS package with Execute SQL Tasks inside a ForEachLoop container using C# programming language. Requirements Microsoft Visual Studio 2008 SQL Server 2008 AdventureWorks2008R2 database (downloadable database file available here) Article If the above requirements are all met, we will begin by launching Microsoft Visual Studio 2008. Create… Read More »