Microsoft.SqlServer.Management.IntegrationServices

person holding smartphone while using laptop

Programmatically Create and Deploy SSIS 2012 Project into Catalog Using C#

Abstract SQL Server Integration Services 2012 comes with a new API for scripting packages which is called MOM – Managed Object Model. In this article, I will demonstrate the scripting of Integration Services Catalog packages using C#. Requirements Microsoft Visual Studio 2010 or later Article We begin by launching Microsoft Visual Studio and create a …

Programmatically Create and Deploy SSIS 2012 Project into Catalog Using C# Read More »

macbook pro

SSIS 2012: Programmatically Create Catalog

Abstract I have a client that has already started migrating existing SQL Server environments to SQL Server 2012. Thus, this article will demonstrate creating a catalog and catalog folder using a Script Task component. Requirements Microsoft Visual Studio 2010 Article We begin by launching Microsoft Visual Studio and creating a new Integration Services Project which …

SSIS 2012: Programmatically Create Catalog Read More »