Select Sifiso

Month: April 2011

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

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#

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#

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#

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#

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 create a SQL view, the second sql task updates the view. Requirements Microsoft Visual Studio 2008 SQL Server 2008 AdventureWorks2008R2 database (downloadable database file available here) Article If the …

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