Abstract This blog post is in response to a request/comment from Thato in this previous article. Hence, I have taken much of the logic used in the aforementioned article and changed it from static to dynamic file compression. Thus, I am still using SQL Server Integration Services‘s Execute Process Task to compress dynamic files into [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 Create Data Flow Task inside a ForEachLoop Container Using C#
June 7, 2011 — SifisoAbstract This article explains how to create an SSIS package with a Data Flow Task 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. [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 →]
Create SSIS Package with SQL Tasks inside a ForEachLoop Container using C#
April 11, 2011 — SifisoAbstract 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 [Read More →]
