Cover Image

Pro SQL server 2012 integration services [electronic resource] / Francis Rodrigues, Michael Coles, David Dye.

Show other versions (2)

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...

Full description

Saved in:
Bibliographic Details
Online Access: Full Text (via Springer)
Main Author: Rodrigues, Francis
Other Authors: Coles, Michael, 1972-, Dye, David
Format: Electronic eBook
Language:English
Published: [Berkeley, CA] : Apress, ©2012.
Series:Expert's voice in SQL server.
Subjects:
SQL server.
Database management.
Client/server computing.
Table of Contents:
  • 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
  • Scripting
  • Events and error handling
  • Data profiling and scrubbing
  • Logging and auditing
  • Heterogeneous sources and destinations
  • Data flow tuning and optimization
  • Parent-child design pattern
  • Dimensional data ETL
  • Building robust solutions
  • Deployment model.

Similar Items