Book description
An in-depth look at the radical changes to the newest release of SISS
Microsoft SQL Server 2012 Integration Services (SISS) builds on the revolutionary database product suite first introduced in 2005. With this crucial resource, you will explore how this newest release serves as a powerful tool for performing extraction, transformation, and load operations (ETL). A team of SQL Server experts deciphers this complex topic and provides detailed coverage of the new features of the 2012 product release. In addition to technical updates and additions, the authors present you with a new set of SISS best practices, based on years of real-world experience that have transpired since the previous edition was published.
Details the newest features of the 2012 SISS product release, which is the most significant release since 2005
Addresses the keys to a successful ETL solution, such as using the right enterprise ETL tool and employing the right ETL architecture in order to meet the system requirements
Includes additional case studies and tutorial examples to illustrate advanced concepts and techniques
Professional Microsoft SQL Server 2012 Integration Services is a valuable resource that meets the demands and high expectations of experienced SSIS professionals.
Table of contents
- Cover
- Contents
- Chapter 1: Welcome to SQL Server Integration Services
- Chapter 2: The SSIS Tools
- Chapter 3: SSIS Tasks
- Chapter 4: Containers
- Chapter 5: The Data Flow
- Chapter 6: Using Variables, Parameters, and Expressions
- Chapter 7: Joining Data
- Chapter 8: Creating an End-to-End Package
- Chapter 9: Scripting in SSIS
- Chapter 10: Loading A Data Warehouse
- Chapter 11: Advanced Data Cleansing in SSIS
- Chapter 12: Using The Relational Engine
- Chapter 13: Accessing Heterogeneous Data
- Chapter 14: Reliability and Scalability
- Chapter 15: Understanding and Tuning the Data Flow Engine
- Chapter 16: SSIS Software Development Life Cycle
- Chapter 17: Error and Event Handling
- Chapter 18: Programming and Extending SSIS
- Chapter 19: Adding a User Interface to Your Component
- Chapter 20: External Management and WMI Task Implementation
- Chapter 21: Using SSIS with External Applications
- Chapter 22: Administering SSIS
- Chapter 23: Case Study: A Programmatic Example
- Introduction
- Advertisements
Product information
- Title: Professional Microsoft SQL Server 2012 Integration Services
- Author(s):
- Release date: March 2012
- Publisher(s): Wrox
- ISBN: 9781118101124
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 2012 Reporting Services
Use your SQL Server skills to create and manage key data reports Deliver interactive business intelligence …
book
Knight's Microsoft SQL Server 2012 Integration Services 24-Hour Trainer
Book-and-video package gets novices up to speed on Microsoft SQL Server 2012 If you need a …
book
Pro SQL Server 2012 Integration Services
Pro SQL Server 2012 Integration Services teaches how to take advantage of the powerful extract, transform, …