SaveToXml – SELECT SIFISO

Programmatically Load and Update Connection Managers of SSIS Package Template

Leave a Comment / File System, LoadFromSqlServer, OLEDB Connection, Reading SSIS Packages, SaveToXml, Updating SSIS Pacakges / By Sifiso

Abstract Recently, I have been contracting on a project that involved updating existing SSIS Package Templates. Thus, this article will demonstrate the 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 creating …

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

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

7 Comments / Creating SSIS Packages, Data Flow Task, Delimited Text Files, Derived Column Transformation, File System, SaveToXml, XML / By Sifiso

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

27 Comments / Creating SSIS Packages, Data Flow Task, Delimited Text Files, File System, OLEDB Connection, SaveToXml / By Sifiso

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 creating a new Integration Services Project …

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

Download & Save SSIS Packages from SQL Server 2008 Instance to XML Format

Leave a Comment / LoadFromSqlServer, SaveToXml, XML / By Sifiso

Abstract This article explains how to Programmatically download SQL Server Integration Services (SSIS) packages from an instance of SQL Server 2008 and save them into an XML file using Microsoft’s SSIS Script Task component. Requirements Microsoft Visual Studio 2008 (or later editions) SQL Server 2005 (or later editions) Article If the above requirements are all …

Download & Save SSIS Packages from SQL Server 2008 Instance to XML Format Read More »