August 2012
Intermediate to advanced
1416 pages
33h 39m
English
book
Microsoft SQL Server 2012 Bible
by Adam Jorgensen, Jorge Segarra, Patrick LeBlanc, Jose Chinchilla, Aaron Nelson
Content preview from Microsoft SQL Server 2012 Bible
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 52
Building, Deploying, and Managing ETL Workflows in Integration Services
In This Chapter
Using New SSIS Features
Understanding Deprecated Features
Performing Basic ETL with SSIS
Constructing Control and Data Flows
Exploring the Full List of Package Elements
Understanding Deployment Models
ETL stands for Extract, Transform, and Load, and is most commonly associated with data warehousing; however, many businesses require ETL processes without ever moving into the realm of the data warehouse. For example, a call center that processes the insurance claims of hundreds of insurance companies must import each client companies' location and policy data. That data must live in both systems, and because both systems almost always have different data schemas, you must perform a constant transform process on the data to achieve proper data integrity and synchronization. Enter the ETL developer armed with SSIS.
Integration Services offers a lot of ETL bang for the buck in the world of Enterprise ETL tools. The multitude of new features offered in SSIS in SQL Server 2012 addresses many of the reported complaints about the steep learning curve and the difficulty of using configurations.
What's New in Integration Services for SQL Server 2012?
A lot. SSIS began with SQL Server 2005 as a dramatic rewrite of Data Transformation Services from SQL Server 2000. In addition to an entirely new design environment, SSIS introduced a suite of powerful functionality with the Data Flow Task, ...
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.