Professional Microsoft Sql Server 2008 Integration Services details from infibeam

About the Book :

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.

About the Author :

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, mentoring and 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

Interesting Facts :

New edition of one of our most successful Wrox books--Pro SQL Server 2005 Integration Services (9780764584350)--with more than 17,000 copies sold.The lead authors are recognized authorities on this technology. The Microsoft SSIS team will again provide tech support and review for this book.Wiley is the leading publisher on data warehousing. The new edition is extensively revised, plus it's expanded by nearly 300 pages.

Contents :

IntroductionWelcome to SQL Server Integration ServicesThe SSIS ToolsSSIS TasksContainersThe Data FlowUsing Expressions and VariablesJoining DataCreating an End-to-End PackageScripting in SSISLoading a Data WarehouseUsing the Relational EngineAccessing Heterogeneous DataReliability and ScalabilityUnderstanding and Tuning the Data Flow EngineSource Control and Software Development Life CycleDTS 2000 MigrationError and Event HandlingProgramming and Extending SSISAdding a User Interface to Your ComponentExternal Management and WMI Task ImplementationUsing SSIS with External ApplicationsAdministering SSISCase Study: A Programmatic ExampleIndex