From the course: Implementing a Data Warehouse with Microsoft SQL Server 2012
Join today to access over 24,800 courses taught by industry experts.
Installing and maintaining SSIS components - SQL Server Tutorial
From the course: Implementing a Data Warehouse with Microsoft SQL Server 2012
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.