Select Sifiso

Month: May 2011

Extract SQL Statements in Execute SQL Tasks and save them into a text delimited file using C#

Abstract This article explains how to extract SQL Statements found in Execute SQL Tasks of an SSIS package and save them into a delimited text file using C# programming language. Requirements Microsoft Visual Studio 2008 Article This article continues from another article which can be found here. Launch Visual Studio 2008 and create an Integration …

Extract SQL Statements in Execute SQL Tasks and save them into a text delimited file using C# Read More »

Extract SQL Statements in Execute SQL Tasks and save them into an Excel Workbook using C#

Abstract This article explains how to extract SQL Statements found in Execute SQL Tasks of an SSIS package and save them into an Excel Workbook using C# programming language. Requirements Microsoft Visual Studio 2008 Article This article continues from another article which can be found here. Launch Visual Studio 2008 and create an Integration Services …

Extract SQL Statements in Execute SQL Tasks and save them into an Excel Workbook using C# Read More »

Extract & Save SQL Statements of Execute SQL Tasks in a ForEach 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 ForEach 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 ForEach Loop 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 »

Extract & Save SQL Statements of Execute SQL Tasks within a Sequence 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 Sequence 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 an …

Extract & Save SQL Statements of Execute SQL Tasks within a Sequence Container using C# Read More »