Professional microsoft SQL server 2012 integration services

Professional microsoft SQL server 2012 integration services

"The 2012 release of Microsoft SQL Server Integration Services (SSIS) offers significant new and enhanced features that greatly expand the capabilities of this product--but only if you know how to exploit them effectively. This book shows you how. It not only covers the latest features of the...

Full description

Bibliographic Details
Main Author: Knight, Brian , 1976- (Author)
Format: Book
Language:English
Published: Indianapolis, Indiana : Wrox/John Wiley & Sons , 2012
Series:Programmer to programmer
Subjects:
Database management
Relational databases
Table of Contents:
  • 1. Welcome to SQL server integration services
  • 2. The SSIS tools
  • 3. SSIS tasks
  • 4. Containers
  • 5. The data flow
  • 6. Using variables, parameters, and expresssions
  • 7. Joining data
  • 8. Creating an end-to-end package
  • 9. Scripting in SSIS
  • 10. Loading a data warehouse
  • 11. Advanced data cleansing in SSIS
  • 12. Using the relational engine
  • 13. Accessing heterogeneous data
  • 14. Reliability and scalability
  • 15. Understanding and tuning the data flow engine
  • 16. SSIS software development life cycle
  • 17. Error and event handling
  • 18. Programming and extending SSIS
  • 19. Adding a user interface to your component
  • 20. External management and WMI task implementation
  • 21. Using SSIS with external applications
  • 22. Administering SSIS
  • 23. Case study: a programmatic example

Similar Items