Pro SQL Server 2005 Integration Services

1. Front Matter

   Pages i-xxvi

   PDF

2. Introducing SQL Server 2005 Integration Services

   Pages 1-12

3. The Architecture of SSIS

   Pages 13-28

4. From DTS to SSIS

   Pages 29-43

5. The IDE and Extending Visual Studio

   Pages 45-72

6. Package Hierarchy

   Pages 73-90

7. Control Flow

   Pages 91-155

8. Maintenance Plans

   Pages 157-169

9. Data Flow Data Sources

   Pages 171-198

10. Basic Data Flow Transformations

    Pages 199-240

11. Advanced Data Flow Transformations

    Pages 241-280

12. Data Flow Destinations

    Pages 281-308

13. Optimization for SSIS

    Pages 309-336

14. SSIS Security

    Pages 337-353

15. Scripting, .NET Style

    Pages 355-385

16. Custom Components

    Pages 387-457

17. Back Matter

    Pages 459-548

    PDF

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!

• .NET
• .NET framework
• Debugging
• Microsoft SQL Server
• SQL
• SQL Server 2005
• database administration
• design
• development

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.

Policies and ethics