Pro SQL Server 2008 Integration Services is the complete reference on Microsoft SQL Server 2008's built-in tool set for extraction, transformation, and load (ETL) projects. Completely updated to cover the very latest features, this book shows how to develop and deploy Integration Services solutions that will scale to load anything from a dozen rows to a billion, or many billions! * Completely revised and updated for SQL Server 2008 * Soup-to-nuts-covers everything you need to be productive with Integration Services * Illustrates best-practice methods yielding solid results for even the most demanding of users Integration Services is the right tool to use for moving data between operational and reporting database environments. Integration Services also lets you move data from nonrelational systems into SQL Server, and vice versa. Integration Services is reliable, it is automated, it will save you time. Pro SQL Server 2008 Integration Services by Dandy Weyn is your guide to making the most of one of Microsoft's most versatile tools.
What you'll learn * Design and automate data flows to and from databases and data warehouses * Implement data transformations in SSIS without writing custom code * Take full advantage of the latest enhancements in SSIS 2008 * Create custom components to support your most complex ETL needs * Optimize your ETL flows and solve SSIS performance problems * Write .NET code that runs inside SQL Server 2008 * Integrate SQL Developer into your general development tool set Who this book is for Pro SQL Server 2008 Integration Services is written for developers and database administrators involved in data extraction, transformation, and loading (ETL) projects. The book helps readers take full advantage of Integration Services to automate the movement and manipulation of data between different databases and nondatabase sources.
Dandy Weyn was born and raised in Belgium, where he started his passion for data at the age of 16, writing his first database application on dBASE III. As trainer/consultant, he travelled the world, sharing his passion for SQL Server and the Microsoft database platform. As a consultant, he worked on multiple enterprise projects to implement solutions around SQL Server Integration Services. Dandy now lives in Redmond, where he works for Microsoft as a curriculum manager focusing on the application platform. Dandy gives presentations at major conferences on SQL Server and Integration Services. He develops hands-on labs built on experience. He works enthusiastically to evangelize, share his knowledge, and help others learn about all that SQL Server and Integration Services have to offer. When his passion is not taken up by working with Microsoft SQL Server, Dandy loves to spend time in the outdoors. You will frequently find him at work to improve his skills on the ski slopes in the beautiful Pacific Northwest.