Microsoft SQL Server 2005 Integration Services Step-By-Step 453pages English software manual

SQL Server 2005 Integration Services Step-By-Step Teach yourself the fundamentals of SQL Server Integration Services - one step at a time. This practical, learn-by-doing tutorial delivers the guidance you need to transform and consolidate data - and build solutions that support your business intelligence needs.

Discover how to:

- Design and execute packages that transform data between files and relational databases
- Configure connection managers to access other data sources
- Create data flows that alter, split, match, and merge data
- Develop event-handlers and monitor package performance
- Encrypt sensitive information and control access to packages
- Customize script code to automate Control Flow and Data Flow tasks
- Debug, troubleshoot, and optimize packages