Select Sifiso

Twitter Linkedin

Month: May 2011

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

52 Comments / Delimited Text Files, Execute SQL Task, Reading SSIS Packages / By

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#

58 Comments / Excel Workbooks, Execute SQL Task, Reading SSIS Packages / By

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#

4 Comments / Execute SQL Task, ForEach Loop Container, Reading SSIS Packages / By

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#

6 Comments / Execute SQL Task, For Loop Container, Reading SSIS Packages / By

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#

12 Comments / Execute SQL Task, Reading SSIS Packages, Sequence Container / By

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 »