Pro SQL Server 2008 Integration Services

1. Auflage. 2010
ISBN: 978-1-4302-1654-4
Verlag: Apress

Buch, Englisch, 600 Seiten, Format (B × H): 178 mm x 235 mm

Integration Services is an increasingly important tool often used in business intelligence applications to pull together data from varying sources for analysis with an eye to providing a sound, data-driven base for key business decisions. Written by an author with a reputation for presenting and teaching on the tool, and with a foreword by the Product Manager responsible for developing the tool, Dandy Weyn’s book is destined to become the go-to title for serious users of SQL Server 2008 Integration Services.

Zielgruppe

Popular/general

Autoren/Hrsg.

Weyn, Dandy

Fachgebiete

• Mathematik | Informatik EDV | Informatik Programmierung | Softwareentwicklung Datenbankprogrammierung SQL Server/MS SQL

Inhaltsverzeichnis

Introducing SQL Server 2008 Integration Services

Updated -- SSIS Architecture

IDE and extending Visual Studio

Package Hierarchy

New Chapter

Control Flow

Maintenance Plans

Data Flow Data Sources

Basic Data Flow

Advanced Data Flow

Data Flow Destinations

Optimization Security

Scripting .NET Style

Custom Components

Custom Components with Designers Moving from DTS to SSIS 2008 and SSIS 2005 to 2008

Summary and closing observations

Appendices:

Updated – Interview with Product team Members

Updated – Package Object Reference

Updated – Control Flow Object Reference

Updated – Maintenance Plan Reference

Updated – Data Flow Sources Reference

Updated – Data Flow Reference

Updated – Data Flow Destinations Reference

Über Autor(innen)

DANDY WEYN was born and raised in Belgium, where he started his passion for data at the age of 16, writing his first database application on Dbase III. As trainer/consultant he travelled the world, sharing his passion for SQL Server and the Microsoft Database Platform. As a consultant he worked on multiple enterprise projects to implement solutions around SQL Server Integration Services. Dandy now lives in Redmond, where he works for Microsoft as a Curriculum Manager focusing on the Application Platform.

Dandy presents at major conferences on SQL Server and Integration Services. He develops hands-on-labs built on experience. He works enthusiastically to evangelize, share his knowledge, and help others learn about all that SQL Server and Integration Services have to offer.
When his passion is not taken up by working with Microsoft SQL Server, Weyn loves to spend time in the outdoors. You will frequently find him at work to improve his skills on the ski slopes in the beautiful Pacific Northwest.