What you will learn from this book
- Ways to quickly move and transform data
- How to configure every aspect of SSIS
- How to interface SSIS with web services and XML
- Techniques to scale the SSIS and make it more reliable
- How to migrate DTS packages to SSIS
- How to create your own custom tasks and user interfaces
- How to create an application that interfaces with SSIS to
manage the environment
- A detailed usable case study for a complete ETL solution
Chapter 1 Welcome to SQL Server Integration Services
Chapter 2 The SSIS tools
Chapter 3 SSIS tasks
Chapter 4 Containers and data flow
Chapter 5 Creating an end-to-end package
Chapter 6 Advanced tasks and transforms
Chapter 7 Scripting in SSIS
Chapter 8 Accessing heterogeneous data
Chapter 9 Reliability and scalability
Chapter 10 Understanding the Integration Services engine
etc.