Abstract SQL Server Integration Services 2012 comes with a new API for scripting packages which is called MOM – Managed Object Model. This API is accessed through the Microsoft.SqlServer.Management.IntegrationServices.dll assembly file. However, when you create an SSIS 2012 project/package using Visual Studio 2010, the assembly file is missing. In this post, I will show you [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 Import Delimited Text File with Derived Columns into Flat File Destination Using SSIS’s Script Task Tool
April 19, 2012 — SifisoAbstract 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 [Read More →]
Download & Save SSIS Packages from SQL Server 2008 Instance to XML Format
February 10, 2012 — SifisoAbstract 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 a 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 [Read More →]
