Get hands-on, practical guidance for using Microsoft SQL Server Integration Services, the next generation data integration platform from Microsoft. Integration Services is a powerful tool for business intelligence, so understanding the essentials-how to develop and deploy SSIS packages, as well as how to apply these skills to data warehousing solutions-is critical to harnessing the full benefits of SQL Server. This step-by-step tutorial teaches you all the essentials for getting started, including data transformation, scripting, security, and best practices for developing enterprise-class data integration applications. With STEP BY STEP, you work at your own pace through hands-on, learn-by-doing exercises. Whether you're a beginning programmer or new to this version of the technology, you'll understand the fundamental techniques for using SQL Server 2005 Integration Services. A companion CD includes data sets and sample code.
