Your hands-on step-by-step guide to building data integration solutions for the enterprise.

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