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 TrainerBecome 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 7
Upgrading Packages to SQL Server 2012
With every new version of Integration Services, there is a path you must follow to upgrade your existing solution to the latest version of the tool. In SQL Server 2012, you can upgrade your 2005 or 2008 SSIS package using the SSIS Package Upgrade Wizard.
The SSIS Package Upgrade Wizard fully upgrades your packages, but you should note a few things upon the completion of the upgrade. The wizard automatically updates connection strings that use an outdated data provider to the latest drivers that come natively with SQL Server. This is a nice feature, but if the packages you are upgrading use configurations to overwrite data source information, as described in Section 7 of this book, you must manually upgrade the providers in the configurations; this wizard, by default, does not upgrade configuration values.
The wizard also does not upgrade packages to utilize many of the new features available in SSIS 2012. For example, it does not upgrade Execute Package Tasks to use the new internal project reference. Also, after converting, the wizard leaves your packages set to the old package deployment model. New packages that are developed in SSIS use the project deployment model, which is detailed in Lesson 8.
You can invoke the SSIS Package Upgrade Wizard by simply opening your packages in SQL Server Data Tools (SSDT) or you can upgrade your packages manually by running SSISUpgrade.exe, the SSIS Package Upgrade Wizard executable (Figure 7-1 ...
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.