Professional Microsoft Sql Server 2008 Integration Services

0.0

Professional SQL Server 2008 Integration Services will, of course, fully cover the new features of the 2008 product release. These features may seem minor from the outside viewer but the learning curve on these features will be challenging. In this new edition, a major focus is on expanding content to reflect best practices based on the nearly 3 years of experience the author team has had since the previous edition published. The authors also expand technical coverage on certain topics that we were not able to address fully in the 2005 edition, providing more value to readers. For example, they have added a new chapter on data warehousing using SSIS and another on methods for managing the SSIS platform.

0.0

Brian Knight SQL Server MVP, MCDBA is the co-founder of SQLServerCentral.com. He has worked with SQL Server for 10 years and has written seven SQL Server books including Professional SQL Server 2005 Integration Services. Brian lives in Jacksonville, FL with his better half and two children. He can be reached at bknight@sqlservercentral.com or by going to http://www.sqlservercentral.com. Erik Veerman is a SQL Server MVP and Mentor for Solid Quality Learning focusing on training, mentoringand architecting solutions on the SQL Server BI platform. Erik has designed dozens of BI solutions across a broad business spectrum-marketing, retail, real estate, finance, teleco, supply chain, and information technology. He led the ETL architecture and design for the first production implementation of Integration Services (SSIS) and assisted with the ETL standards and best practices for SSIS on Microsofts SQL Server 2005 reference initiative, Project REAL. Erik is a co-leader of the Atlanta SQL Users group and is a frequent speaker at SQL Server events locally and abroad. Douglas Hinson has worked as an independent software and database consultant in the logistics and financial industries, with an extensive SQL Server background. He has co-authored several Wrox books including Professional SQL Server 2005 Integration Services. Darren Herbold is a Principal Consultant at Pragmatic Works Consulting with expertise in Business Intelligence and .Net development on the Microsoft platform. Darren is an MCDBA, MCSE, trainer, and author. He has also spoken at local SQL Server User groups and SQL Saturday training camps. Darren can be reached via email at: dherbold@pragmaticworks.com Table of Contents Introduction Welcome to SQL Server Integration Services The SSIS Tools SSIS Tasks Containers The Data Flow Using Expressions and Variables Joining Data Creating an End-to-End Package Scripting in SSIS Loading a Data Warehouse Using the Relational Engine Accessing Heterogeneous Data Reliability and Scalability Understanding and Tuning the Data Flow Engine Source Control and Software Development Life Cycle DTS 2000 Migration Error and Event Handling Programming and Extending SSIS Adding a User Interface to Your Component External Management and WMI Task Implementation Using SSIS with External Applications Administering SSIS Case Study: A Programmatic Example Index