|
Professional SQL Server 2008 Integration Services; About the Authors; Credits; Acknowledgments; Contents; Introduction; Who This Book Is For; What This Book Covers; How This Book Is Structured; What You Need to Use This Book; Conventions; Source Code; Errata; p2p.wrox.com; Chapter 1: Welcome to SQL Server Integration Services; SQL Server SSIS Historical Overview; What's New in SSIS; Getting Started; Architecture; Precedence Constraints; Containers; Variables; Data Flow Elements; Error Handling and Logging; Editions of SQL Server; Summary; Chapter 2: The SSIS Tools; Import and Export Wizard |
Business Intelligence Development StudioCreating Your First Package; The Solution Explorer Window; The SSIS Package Designer; Package Installation Wizard; Management Studio; Summary; Chapter 3: SSIS Tasks; SSIS Task Objects; Looping and Sequence Tasks; Scripting Tasks; Analysis Services Tasks; Data Flow Task; Data Preparation Tasks; RDBMS Server Tasks; Workflow Tasks; SMO Administration Tasks; Summary; Chapter 4: Containers; Task Host Containers; Sequence Containers; Groups; For Loop Container; Foreach Loop Container; Summary; Chapter 5: The Data Flow; The Data Flow; Data Viewers; Sources |
DestinationsTransformations; Data Flow Example; Summary; Chapter 6: Using Expressions and Variables; The Paradigm; Understanding Data Types; Using Variables; Working with Expressions; Summary; Chapter 7: Joining Data; The Lookup Component; The Merge Join Component; Contrasting to the Relational Join; New Lookup Features; Building the Basic Package; Using the Lookup Component; Cache Connection Manager and Transform; Summary; Chapter 8: Creating an End-to-End Package; Basic Transformation Tutorial; Typical Mainframe ETL with Data Scrubbing; Looping and the Dynamic Task; Summary |
Chapter 9: Scripting in SSISScripting?; Getting Started in SSIS Scripting; Using the Script Task; Using the Script Component; Essential Coding, Debugging, and Troubleshooting Techniques; Summary; Chapter 10: Loading a Data Warehouse; Data Profiling; Data Extraction; Dimension Table Loading; Fact Table Loading; SSAS Processing; Master ETL Package; Summary; Chapter 11: Using the Relational Engine; Data Extraction; SQL Server 2008 Change Data Capture; Data Loading; Summary; Chapter 12: Accessing Heterogeneous Data; Excel and Access; Oracle; XML and Web Services; Flat Files; ODBC |
Other Heterogeneous SourcesSummary; Chapter 13: Reliability and Scalability; Restarting Packages; Package Transactions; Error Outputs; Scaling Out; Summary; Chapter 14: Understanding and Tuning the Data Flow Engine; The SSIS Engine; SSIS Data Flow Design and Tuning; Pipeline Performance Monitoring; Summary; Chapter 15: Source Control and Software Development Life Cycle; Introduction to Software Development Life Cycles; Versioning and Source Code Control; Code Deployment and Promotion from Development to Test to Production; Summary; Chapter 16: DTS 2000 Migration |
Managing DTS 2000 Packages within SQL Server Management Studio |