Microsoft 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 CD features: * All practice exercises * Sample databases * Fully searchable eBook For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.