IntegrationServices

black screen with code

Load Integration Services Assembly File Into Visual Studio 2010 Project

1 Comment / API, IntegrationServices, Managed Object Model, Microsoft Visual Studio 2010, SQL Server 2012, SSIS 2012, XML / By

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 …

Load Integration Services Assembly File Into Visual Studio 2010 Project 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 »