Programmer to Programmer - Knight B., Veerman E., Moss J., Davis M., Rock C. - Professional Microsoft SQL Server 2012 Integration Services

Programmer to Programmer - Knight B., Veerman E., Moss J., Davis M., Rock C. - Professional Microsoft SQL Server 2012 Integration Services Professional Microsoft SQL Server 2012 Integration Services

Год: 2012
Автор: Brian Knight, Erik Veerman, Jessica M. Moss, Mike Davis, Chris Rock
Издательство: Wrox
ISBN: 978-1-1181-0112-4
Серия: Programmer to Programmer
Язык: Английский
Формат: PDF
Качество: Изначально компьютерное (eBook)
Интерактивное оглавление: Нет
Количество страниц: 964
Описание: 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.

Примеры страниц

Оглавление
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