Select Sifiso

Reading SSIS Packages

Programmatically Load and Update Connection Managers of SSIS Package Template

Abstract Recently, I have been contracting on a project that involved updating existing SSIS Packate Templates. Thus, this article will demonstrate loading and updating of SSIS Package Templates using a Script Task component. Requirements Microsoft Visual Studio 2008 SQL Server 2005 (or later editions) Article We begin by launching Microsoft Visual Studio and create a …

Programmatically Load and Update Connection Managers of SSIS Package Template Read More »

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 »

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 »