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.