September 2010
Beginner to intermediate
424 pages
12h 17m
English
book
Knight's Microsoft® Business Intelligence 24-Hour Trainer: Leveraging Microsoft SQL Server® Integration, Analysis, and Reporting Services with Excel® and SharePoint®
by Brian Knight, Devin Knight, Adam Jorgensen, Patrick LeBlanc, Mike Davis
Content preview from Knight's Microsoft® Business Intelligence 24-Hour Trainer: Leveraging Microsoft SQL Server® Integration, Analysis, and Reporting Services with Excel® and SharePoint®
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.
Deploying SSIS Packages
Now that all of your packages have been created, you will need to deploy them to either an
instance of SQL Server or a file system location using one of the many approaches that are avail-
able. Each approach ultimately accomplishes the same goal; however, the method of choice will
probably depend on the number of packages you plan to deploy. As with most Microsoft tools,
you have numerous ways to accomplish the same task. Both Business Intelligence Development
Studio (BIDS) and SQL Server Management Studio (SSMS) include tools and wizards that sim-
plify the deployment of SSIS packages. There are three main deployment choices available to you:
Deploy a single package using SSMS.
Deploy a single package to a SQL Server instance or file location using BIDS.
Create a deployment utility using BIDS.
The first two methods allow you to deploy only a single package at a time. The third approach,
on the other hand, allows you to configure and deploy multiple packages simultaneously.
DEPLOYING A SINGLE PACKAGE USING SSMS
If you are deploying only a single SSIS package this maybe a viable approach. Using SSMS, con-
nect to the SSIS instance to which you will be deploying the package. As stated earlier, you can
deploy a package to an instance of SQL Server or to a file location. When you are connected to
an SSIS instance, expand the Stored Packages folder in the Object Ex ...
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.