Expert SQL Server 2005 Integration Services
Chapter 1: Getting Started.
Chapter 2: Extending Scripts in SSIS.
Chapter 3: Data Extraction.
Chapter 4: Dimension ETL with SSIS.
Chapter 5: Fact Table ETL.
Chapter 6: Processing Analysis Services Objects with SSIS.
Chapter 7: Package Reliability.
Chapter 8: Deployment.
Chapter 9: Managing SSIS.
Chapter 10: Handling Heterogeneous and Unusual Data.
Chapter 11: Migrating from DTS to SSIS.
Chapter 12: Scaling SSIS.
Erik Veerman (SQL Server MVP, MCT, MCDBA) is a Mentor for Solid Quality Learning focusing on training, mentoring, and architecting solutions on the SQL Server Business Intelligence (BI) platform. His industry recognition includes Microsoft’s Worldwide BI Solution of the Year and SQL Server Magazine’s Innovator Cup winner. He has designed dozens of BI solutions across a broad business spectrum—telecommunications, marketing, retail, commercial real estate, finance, supply chain, and information technology. His experience with high-volume, multi-terabyte environments and SQL Server 64-bit has enabled clients to scale their Microsoft-based BI solutions for optimal potential. As an expert in OLAP design, ETL processing, and dimensional modeling, he is a presenter, author, and instructor. He led the ETL architecture and design for the first production implementation of SQL Server Integration Services (SSIS) and helped drive the ETL standards and best practices for SSIS on Microsoft’s SQL Server 2005 reference initiative (Project REAL). He also co-authored Professional SQL Server 2005 Integration Services (Wiley Publishing, 2006). As a resident of Atlanta, Georgia, Erik is a leader of the local Atlanta SQL Server User’s Group, a PASS and INETA user group chapter.
|All code from the book
|2.68 MB||Click to Download|
|Chapter7EnterpriseLog.sql||479 bytes||Click to Download|
Do you think you've discovered an error in this book? Please check the list of errata below to see if we've already addressed the error. If not, please submit the error via our Errata Form. We will attempt to verify your error; if you're right, we will post a correction below.
|13||error in variable
|5||Error in Figure
The order date needs to come between the start and end date.