Abstract This article explains how to create an SSIS package with Execute SQL Tasks inside a For Loop container using C# programming language. Requirements Microsoft Visual Studio 2008 SQL Server 2008 AdventureWorks2008R2 database (downloadable database...

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...

Abstract This article explains how to create an SSIS package using C# programming language. The package contains two SQL tasks: the first SQL task drops and creates a SQL view, and the second SQL task updates the view. Requirements Microsoft Visual Studio...