Microsoft® SQL Server(TM) 2005 Integration Services Step by Step - Softcover

Paul Turley; Joe Kasprzak; Scott Cameron; Satoshi Iizuka; Pablo Guzman; Hitachi Consulting

Softcover

ISBN 10: 0735624054 ISBN 13: 9780735624054

Publisher: Microsoft Press, 2007

Synopsis

Teach yourself the fundamentals of SQL Server Integration Services—one step at a time. This practical, learn-by-doing tutorial delivers the guidance you need to transform and consolidate data—and build solutions that support your business intelligence needs.

Discover how to:

• Design and execute packages that transform data between files and relational databases
• Configure connection managers to access other data sources
• Create data flows that alter, split, match, and merge data
• Develop event-handlers and monitor package performance
• Encrypt sensitive information and control access to packages
• Customize script code to automate Control Flow and Data Flow tasks
• Debug, troubleshoot, and optimize packages

CD features:

• All practice exercises
• Sample databases
• Fully searchable eBook

For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.

About this title

From the Publisher:

Key Book Benefits:

-Provides hands-on exercises that help develop proficiency quickly

-Features expertise from Hitachi Consulting, which creates specialized SQL Server-based data solutions for corporate customers

-Includes a companion CD with sample data sets and code

About the Author:

Paul Turley, Joe Kasprzak, Scott Cameron, Satoshi Iizuka, and Pablo Guzman are each business intelligence experts who work for Hitachi Consulting.

About this edition

• Publisher: Microsoft Press
• Publication date: 2007
• ISBN 10: 0735624054
• ISBN 13: 9780735624054
• Binding: Paperback
• Number of pages: 480