November 2012
Beginner
528 pages
12h 9m
English
book
Knight's Microsoft SQL Server 2012 Integration Services 24-Hour Trainer
by Brian Knight, Devin Knight, Mike Davis, Wayne Snyder
Content preview from Knight's Microsoft SQL Server 2012 Integration Services 24-Hour Trainer
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Chapter 53
Deploying Packages to the Package Catalog
In SQL Server 2005, 2008, and still in the package deployment model, you would deploy packages into SQL Server’s msdb database or to the filesystem. Now, in SQL Server 2012’s project deployment model, you deploy to the SSIS catalog (ssisdb database). Deploying to this model enables you to activate some of the newer features in SSIS, like environments and parameterization of packages (to name just a few). Deploying packages is simple using the Integration Services Deployment Wizard.
NOTE Because the older package deployment model is legacy, deploying packages to this model is not covered in this lesson in length.
Using the Deployment Wizard
The Deployment Wizard is the easiest way to deploy packages to the catalog. You can access the wizard through SSDT by right-clicking a project and selecting Deploy. You can also access it through Management Studio or by double-clicking an .ISPAC file. The wizard installs your packages by asking the administrator a few questions. It also creates the .ISPAC file, which is a single file that can be handed to a customer or to the DBA to install your project.
Once the wizard is open and you bypass the opening screen, you’re asked which server and folder you want to deploy your project to (see Figure 53-1). (A folder is a container for a number of projects.) Click Next and Deploy to push your packages to the server. You’ll also be warned if the packages are already on the server. Remember ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.