LoadFromSqlServer

person holding apple magic mouse

Programmatically Load and Update Connection Managers of SSIS Package Template

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 »

close up of laptop keyboard

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

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 »