Microsoft SQL Server 2005 Integration Services Step by Step

Paul Turley, Joe Kasprzak, Scott Cameron, Satoshi Iizuka, Pablo Guzman, Hitachi Consulting0735624054, 9780735624054

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.