Hands-On Microsoft SQL Server 2008 Integration Services

A practical guide to mastering Microsoft SQL Server 2008 Integration Services. Hands-On Microsoft SQL Server 2008 Integration Services makes learning SSIS easier through the use of extensive exercises structured around every component within the tool. The complex topics of embedding control flow tasks and containers in a data workflow and using data transformations in the data flow are covered with real-world examples and step-by-step methods. Hands-On Microsoft SQL Server 2008 Integration Services features: Details on installation, control flow, data flow transformations, administration, security, and troubleshooting; Two new chapters on extending SSIS through scripting/programming and standard methods for developing a data warehouse architecture; New advanced examples throughout each chapter; Hands-on exercises that are broken down into objectives, solution methodologies, numbered steps, and review for reinforcing techniques; A focus on real-world data warehousing solutions that can be easily applied to your own business challenges. Comprehensive coverage of SSIS:. Introducing SSIS; Import and Export Wizard; SSIS Workflow Nuts and Bolts; Control Flow Containers; Control Flow Tasks; Administration; Securing Packages; Advanced Features; Data Flow Components; Data Flow Transformations; Deploying Packages; Migrating; Troubleshooting and Performance Enhancements; Extending SSIS; Star Schema Data Warehouse Architecture