Microsoft.SqlServer.Management.IntegrationServices

person holding smartphone while using laptop

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

3 Comments / API, Catalog, CatalogFolder, Creating SSIS Packages, Microsoft Visual Studio 2010, SMO Server, SQL Server 2012, SSIS 2012 / By

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

Leave a Comment / Catalog, CatalogFolder, IntegrationServices, SMO Server, SSIS 2012 / By

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 »