From the course: Implementing a Data Warehouse with Microsoft SQL Server 2012

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Installing and maintaining SSIS components

Installing and maintaining SSIS components - SQL Server Tutorial

From the course: Implementing a Data Warehouse with Microsoft SQL Server 2012

Start my 1-month free trial

Installing and maintaining SSIS components

“

I'd like to talk about installing and maintaining the SSIS components necessary to deploy SSIS packages. In previous versions of SSIS we would deploy packages one at a time. And we would deploy them to the msdb system database or to the file system. Now in SSIS 2012 we deploy a project. And a project can contain multiple packages along with different support files and parameters. Those projects will be deployed to an Integration Service Catalog, and I'm going to show you now how to create an Integration Service Catalog. We'll use SQL Server Management Studio for this. In the Object Explorer under Databases under Security, one of the last options I'll get is Integration Services Catalogues. If I open that tree item now you'll see it's empty. I'm going to right click and say Create Catalog. I'm presented with a Create Catalog wizard. It's just a one screen wizard, don't have to answer a whole lot of questions. At the top, you'll see a check box for enable CLR integration. The catalog…

Contents