From the course: Implementing a Data Warehouse with Microsoft SQL Server 2012
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Configuring advanced SSIS settings - SQL Server Tutorial
From the course: Implementing a Data Warehouse with Microsoft SQL Server 2012
Configuring advanced SSIS settings
In this section, I'd like to talk about setting some advanced options on the Integration Services Catalog. If we look at the Integration Services Catalog we created earlier, SSISDB, right-click and look at the Properties. Notice some of these properties we can change in this interface, but other properties are grayed out. If you read the note at the bottom, it says, the database must be in single user mode in order to change this property. So, I'd like to demonstrate how to put a database into single user mode then change the property and then go back to multi-user mode. I've state some code for you to do this, in your Exercise Files. For now, let's just copy the top three statements, into SQL Management Studio, and we'll see these statements are very straightforward. We're going to ALTER the database. We're going to set it in single user mode, and the last phrase with ROLLBACK IMMEDIATE, will cause any currently running transactions to roll back and be disconnected. So you want to be…
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.