SQL Server Integration Services is groundbreaking. It exists for both the DBA and the developer, as well as that new role SSIS has created between the two-the data artisan.Pro SQL Server 2005 Integration Servicescontains everything you could ever hope to know about this exciting new development from Microsoft: developer insight, Microsoft group managerlevel access, personal experience of using the technology in the realworld, and finegrained analysis. If you want to rapidly gain knowledge and context from your data, Microsoftrs"s latest and greatest interpretation of Enterprise Application Integration, SQL Server Integration Services, is for you. As part of the extensive SQL Server suite, Integration Services is a more serious and expandable interpretation of the integration paradigm than previously available. At once both simple to use yet incredibly complex, it goes far beyond being a reimagining and reengineering of DTS, and its all presented in a familiar Visual Studio context. Itrs"s Agile, itrs"s service-oriented, itrs"s everything to everyone.Written for the developer, the DBA, and the data artisan,Pro SQL Server 2005 Integration Serviceswill show you how to develop and deploy enterprise SSIS solutions in multibillionitem environments. Its everything SSIS, explained for everyone! What yours"ll learn Understand how to develop and deploy SSIS solutions that will perform in multibillionitem environments from an author who has been there and done it. Build bespoke custom components tailored to your projects exact requirements. Create perfomant and scalable solutions with an eye to future requirements and upgrades. Who is this book for?This book is for anyone working with SQL Server who has an interest in the Integration Services technology. Deep experience of SQL Server 2005 is not expected, however, you should be comfortable with fundamental techniques. About the Apress Pro SeriesThe Apress Pro series books are practical, professional tutorials to keep you on and moving up the professional ladder.You have gotten the job, now you need to hone your skills in these tough competitive times. The Apress Pro series expands your skills and expertise in exactly the areas you need. Master the content of a Pro book, and you will always be able to get the job done in a professional development project. Written by experts in their field, Pro series books from Apress give you the hardwon solutions to problems you will face in your professional programming career. Related Titles from Apress Pro SQL Server 2005 Pro SQL Server 2005 Reporting Services

Introducing SQL Server 2005 Integration Services	p. 1
The Architecture of SSIS	p. 13
From DTS to SSIS	p. 29
The IDE and Extending Visual Studio	p. 45
Package Hierarchy	p. 73
Control Flow	p. 91
Maintenance Plans	p. 157
Data Flow Data Sources	p. 171
Basic Data Flow Transformations	p. 199
Advanced Data Flow Transformations	p. 241
Data Flow Destinations	p. 281
Optimization for SSIS	p. 309
SSIS Security	p. 337
Scripting, .NET Style	p. 355
Custom Components	p. 387
Interview with Donald Farmer	p. 459
The Package Object	p. 463
The Control Flow Object	p. 477
Maintenance Plans Reference	p. 509
Data Flow Object Reference	p. 519
Index	p. 523
Table of Contents provided by Blackwell. All Rights Reserved.

Supplemental Materials

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.