Pro SQL Server 2005 Integration Services

• Main Author: Wightman, James (Author)
• Corporate Author: SpringerLink (Online service)
• Format: Electronic eBook
• Language: English
• Published: Berkeley, CA : Apress, 2008.
• Subjects: Computer science.; Software engineering.; Computer Science.; Software Engineering/Programming and Operating Systems.

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...

Table of Contents:

• 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.