Select Sifiso

For Loop Container

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

Abstract This article explains how to create an SSIS package with a Data Flow Task inside a ForLoop 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. …

Programmatically Create Data Flow Task inside a ForLoop Container Using C# Read More »

Extract & Save SQL Statements of Execute SQL Tasks in a For Loop Container using C#

Abstract This article explains how to extract and save SQL Statements found in Execute SQL Tasks of an SSIS package that contains For Loop container using C# programming language. Requirements Microsoft Visual Studio 2008 SQL Server 2008 Article This article continues from another article which can be found here. Launch Visual Studio 2008 and create …

Extract & Save SQL Statements of Execute SQL Tasks in a For Loop Container using C# Read More »

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

Abstract This article explains how to create an SSIS package with Execute SQL Tasks inside a For Loop 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 SSIS Package with SQL Tasks inside a For Loop Container using C# Read More »