Pro SQL Server 2005 Integration Services

This book covers everything an SQL Server developer needs to know about SSIS from deployment to debugging to performance, all proven by implementation. It is written by an author who has been uniquely and closely involved with SSIS since its beta-cycle.

SQL Server 2005 Integration Services (SSIS) is a powerful and widely adopted SQL Server technology. It allows information from a number of data sources to be rapidly integrated together to provide an effective data management, performance and control for system dealing with anything from a few hundred thousand elements to those where multi-billion elements are common.

This book offers complete coverage on SQL Server 2005 Integration Services, from using existing components to writing complex Custom Controls with their own User-Interface, all proven by implementation. Written by an author who has been using SSIS since its inception this book uses efficient best practice methods to achieve results for the most demanding user.

Written by an author who has been uniquely and closely involved with SSIS since its beta-cycle Covers everything an SQL Server developer needs to know about SSIS from deployment to debugging to performance Goes beyond the traditional coverage of existing books to discuss how Custom Controls can be used to get the very greatest productivity from SSIS

Autorentext
James Wightman is an average guy. A programmer, problem solver, artist, and artisan, he loves his work and his family, and he's looking for that one chance to change the world. Born in 1975, James spent his formative years reading Marvel comics and books by Tolkien before discovering computers in 1980. Teaching himself to program computers at the age of 6, he wrote himself a teaching aid to learn pure mathematics and then translated the program into Z80 machine language. From there, he learned C and then became adept with 68000 assembly language and eventually C++, writing two games one released commercially for the Commodore Amiga. James is an innovator in many ways and in many areas. At age 11, he invented a way for aircraft to land with increased safety, and at age 12, he invented a VCR that could record four simultaneous broadcast streams onto a standard VHS tape. That you don't own a VCR that records four channels at once and that aircraft still make a squealing sound when their wheels touch tarmac indicate how well the designs of a preteen are received by companies such as Sony and Boeing. His next invention will rock the world to its very foundations. Or at least cause a ripple. Maybe. So he hopes. Having worked on the largest of Microsoft technology led projects for some of the biggest companies worldwide for the past 15 years, James is honored to have worked on his second book, Pro SQL Server 2005 Integration Services, and hopes that writing will remain a part of his ongoing commitment to programming and the programming community. Currently, his time is taken up learning the Mandarin, Japanese, and Russian languages as well as spending time on the MSDN forums trying to help his peers. In his spare time, he works on his next books for Apress. He was also recently voted in as a school governor. In his work life, James is technical lead on a project in cooperation with Microsoft which could, quite literally, save the planet.

Inhalt
Introducing SQL Server 2005 Integration Services.- The Architecture of SSIS.- From DTS to SSIS.- The IDE and Extending Visual Studio.- Package Hierarchy.- Control Flow.- Maintenance Plans.- Data Flow Data Sources.- Basic Data Flow Transformations.- Advanced Data Flow Transformations.- Data Flow Destinations.- Optimization for SSIS.- SSIS Security.- Scripting, .NET Style.- Custom Components.