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 [Read More →]
select SIFISO Hey, let's DEV IT!
Sifiso W. Ndlovu
I am a certified Microsoft Professional based in Johannesburg, South Africa.
I have over 6 years working within Microsoft SQL Server and .Net environments.
I am currently studying towards Masters in IT at the University of Johannesburg.
Programmatically Load and Update Connection Managers of SSIS Package Template
June 23, 2012 — Sifiso
Extract SQL Statements in Execute SQL Tasks and save them into a text delimited file using C#
May 10, 2011 — SifisoAbstract 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 [Read More →]
Extract SQL Statements in Execute SQL Tasks and save them into an Excel Workbook using C#
May 10, 2011 — SifisoAbstract 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 [Read More →]
Extract & Save SQL Statements of Execute SQL Tasks in a ForEach Loop Container using C#
May 10, 2011 — SifisoAbstract 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 [Read More →]
Extract & Save SQL Statements of Execute SQL Tasks in a For Loop Container using C#
May 5, 2011 — SifisoAbstract 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 [Read More →]
Extract & Save SQL Statements of Execute SQL Tasks within a Sequence Container using C#
May 4, 2011 — SifisoAbstract 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 [Read More →]
Extract & Save SQL Statements in Execute SQL Tasks using C#
April 7, 2011 — SifisoAbstract 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 [Read More →]
