Select Sifiso

file

Programmatically Import Delimited Text File with Derived Columns into Flat File Destination Using SSIS’s Script Task Tool

Abstract This article is in response to a request that was sent by one of my blog’s subscribers regarding scripting an SSIS package with derived columns that sources text file and writes data into another text file. Thus, this article demonstrates creating a SQL Server Integration Services package that imports a text file with derived …

Programmatically Import Delimited Text File with Derived Columns into Flat File Destination Using SSIS’s Script Task Tool Read More »

Programmatically Import Flat File Data Source into SQL Server 2008 Using SSIS’s Script Task Tool

Abstract This article demonstrates creating a SQL Server Integration Services package that imports a text file into SQL Server database table using a Script Task component. Requirements Microsoft Visual Studio 2008 SQL Server 2005 (or later editions) create_table_script.txt flat_src.txt selectSIFISO_Flat_File_Source_into_OLE_DB_Destination_Using_CSharp.txt Article We begin by launching Microsoft Visual Studio and create a new Integration Services Project …

Programmatically Import Flat File Data Source into SQL Server 2008 Using SSIS’s Script Task Tool Read More »

Programmatically Execute File System Package Task Using C#

Abstract This article explains how to execute an SSIS package task of a package that is stored in a file system. Requirements Microsoft Visual Studio 2008 (or later editions) SQL Server 2005 (or later editions) AdventureWorks2008R2 database (downloadable database file available here) Article If the above requirements are all met, we will begin by launching …

Programmatically Execute File System Package Task Using C# 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 »