April 2011 – SELECT SIFISO

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

16 Comments / Creating SSIS Packages, Execute SQL Task, Sequence Container / By Sifiso

Abstract This article explains how to create an SSIS package with Execute SQL Tasks inside a Sequence 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 …

Create SSIS Package with SQL Tasks inside a Sequence Container using C# Read More »

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

35 Comments / Creating SSIS Packages, Execute SQL Task, ForEach Loop Container / By Sifiso

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 …

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

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

8 Comments / Creating SSIS Packages, Execute SQL Task, For Loop Container / By Sifiso

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 »

Extract & Save SQL Statements in Execute SQL Tasks using C#

4 Comments / Execute SQL Task, Reading SSIS Packages / By Sifiso

Abstract This article explains how to extract and save SQL Statements in Execute SQL Tasks of an SSIS package using C# programming language. Requirements Microsoft Visual Studio 2008 SQL Server 2008 Article I have been recently been tasked by my boss at work to extract the SQL Statements in an SSIS package that contained over …

Extract & Save SQL Statements in Execute SQL Tasks using C# Read More »

Create SSIS Package with SQL Tasks using C#

23 Comments / Creating SSIS Packages, Execute SQL Task / By Sifiso

Abstract This article explains how to create an SSIS package using C# programming language. The package contains two SQL tasks: the first SQL task drops and creates a SQL view, and the second SQL task updates the view. Requirements Microsoft Visual Studio 2008 SQL Server 2008 AdventureWorks2008R2 database (downloadable database file available here) Article If …

Create SSIS Package with SQL Tasks using C# Read More »