Book description
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. SQL Server Integration Services (SSIS) facilitates an unprecedented ability to load data from anywhere, perform any type of manipulation on it, and store it to any source.
Whether you are populating databases, retrieving data from the Web, or performing complex calculations on large data sets, SSIS gives you the tools to get the job done. And this book gives you the knowledge to take advantage of everything SSIS offers.
Helps you design and develop robust, efficient, scalable ETL solutions
Walks you through using the built-in, stock components
Shows how to programmatically extend the power of SSIS to cover any possible scenario
Table of contents
- Title
- Dedication
- Contents at a Glance
- Contents
- About the Authors
- About the Technical Reviewer
- CHAPTER 1: Introducing Integration Services
- CHAPTER 2: BIDS and SSMS
- CHAPTER 3: Hello World—Your First SSIS 2012 Package
- CHAPTER 4: Connection Managers
- CHAPTER 5: Control Flow Basics
- CHAPTER 6: Advanced Control Flow Tasks
- CHAPTER 7: Source and Destination Adapters
- CHAPTER 8: Data Flow Transformations
- CHAPTER 9: Variables, Parameters, and Expressions
- CHAPTER 10: Scripting
- CHAPTER 11: Events and Error Handling
- CHAPTER 12: Data Profiling and Scrubbing
- CHAPTER 13: Logging and Auditing
- CHAPTER 14: Heterogeneous Sources and Destinations
- CHAPTER 15: Data Flow Tuning and Optimization
- CHAPTER 16: Parent-Child Design Pattern
- CHAPTER 17: Dimensional Data ETL
- CHAPTER 18: Building Robust Solutions
- CHAPTER 19: Deployment Model
- Index
Product information
- Title: Pro SQL Server 2012 Integration Services
- Author(s):
- Release date: June 2012
- Publisher(s): Apress
- ISBN: 9781430236924
You might also like
book
Professional Microsoft SQL Server 2014 Integration Services
Fill the gap between planning and doing with SSIS 2014 The 2014 release of Microsoft's SQL …
book
Microsoft SQL Server 2019: A Beginner's Guide, Seventh Edition, 7th Edition
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, …
book
Microsoft SQL Server 2014 Unleashed
The industry’s most complete, useful, and up-to-date guide to SQL Server 2014. You’ll find start-to-finish coverage …
book
Microsoft SQL Server 2012 Bible
Harness the powerful new SQL Server 2012 Microsoft SQL Server 2012 is the most significant update …