SQL Server Integration Services is groundbreaking. It exists for both the database administrator and the developer, as well as that new role SSIS has created between the two-the data artisan.
Pro SQL Server 2005 Integration Services
contains everything you could ever hope to know about this exciting development from Microsoft: developer insight, Microsoft group manager-level access, personal experience of using the technology in the real-world, and fine-grained analysis. If you want to rapidly gain knowledge and context from your data, Microsoft'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 it's all presented in a familiar Visual Studio context. It's agile, it's service-oriented, it's everything to everyone.
Written for the developer, the database administrator, and the data artisan,
Pro SQL Server 2005 Integration Services
will show you how to develop and deploy enterprise SSIS solutions in multibillion-item environments. It's everything SSIS, explained for everyone!
Edition
Language
Place of publication
Target group
Illustrations
Dimensions
Height: 235 mm
Width: 191 mm
Thickness: 32 mm
Weight
ISBN-13
978-1-59059-897-9 (9781590598979)
DOI
10.1007/978-1-4302-0448-0
Schweitzer Classification
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.
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.
