Catalog

Execute All Packages Within SSIS Project Catalog

Leave a Comment / Catalog, Execute Package Task, Project Deployment Model / By

The SSIS Project Deployment Model is great! It really is the best thing since sliced bread! I specifically appreciate the package execution logging and reporting that is provided by this model but …. (there is always a but :), right), lately I’ve been looking for ways to execute all packages within a project at once. …

Execute All Packages Within SSIS Project Catalog 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 »