Pro SQL Server 2012 Integration Services teaches how to take advantage of the powerful extract, transform and load (ETL) platform included with Microsoft SQL Server 2012. You’ll learn to build scalable, robust, performance-driven enterprise ETL solutions that save time and make money for your company. You'll learn to avoid common ETL development pitfalls and how to extend the power of your ETL solutions to include virtually any possible transformation on data from any conceivable source.
· Introducing Integration Services
· BIDS and SSMS
· “Hello World!”-Your First SSIS 2012 Package
· Connection Managers
· Control Flow Basics
· Advanced Control Flow Tasks
· Source and Destination Adapters
· Data Flow Transformations
· Variables, Parameters and Expressions
· Events and Error Handling
· Data Profiling and Scrubbing
· Logging, Auditing and Data Lineage
· Heterogeneous Sources and Destinations
· Data Flow Tuning and Optimization
· Parent-Child Design Pattern
· Dimensional Data ETL
· Building Robust Solutions
· Deployment Model
This book gives you the information you'll need to build powerful, scalable and efficient ETL solutions at any level of complexity.
Francis Rodrigues is a business intelligence consultant based out of New York City. A computer science graduate of Loyola College in Maryland, he is an expert developer of enterprise business intelligence projects. His specialties include extract, transfer, load (ETL) solutions based on SQL Server, SQL Server Integration Services (SSIS) and Oracle.
Michael Coles has more than a decade's experience designing and administering SQL Server databases. A prolific writer of articles on all aspects of SQL Server, particularly on the expert use of T-SQL, he holds MCDBA and MCP certifications. He graduated magna cum laude with a Bachelor of Science degree in information technology from American Intercontinental University in Georgia.
David Dye is a Microsoft SQL Server MVP, instructor and author specializing in relational database management systems, business intelligence systems, reporting solutions and Microsoft SharePoint. For the past 9 years David's expertise has been focused on Microsoft SQL Server development and administration.