Microsoft SQL Server 2005 Integration Services

Kirk Haselden (Autor)

Buch | Softcover

744 Seiten

2006
Sams Publishing (Verlag)
978-0-672-32781-0 (ISBN)

Titel ist leider vergriffen;
keine Neuauflage

Artikel merken

Offering an introduction to the basic concepts underlying Integration Services, this title explains the details of how to work in the Integration Services environment, including how to set up stock components, use the various designer features, and practical advice on configuring, deploying, securing, and managing packages.

All medium to large companies have to deal with data being stored in a number of databases, spreadsheets and proprietary applications. Bringing all this data together into one system can be useful to analyzing the business; but can also be quite difficult to do. Integration Services is the next big bet in Microsoft's business intelligence lineup. It provides true enterprise extract transform and load features (ETL). Analysts estimate that up to 80 percent of business intelligence system costs are expended on ETL processing. Integration Services makes implementing ETL processes simpler by virtually eliminating the need for custom coded solutions, thereby saving time and money. Integration Services also provides a rich development environment that's well integrated with Analysis Services and Reporting Services (both of which have proved to be very popular among database developers in 2004). Integration Services makes true enterprise level business intelligence more accessible to the masses. This book will concentrate on providing real world solutions to real world problems giving readers a head start on their various projects. Some readers may only be evaluating Integration Services and will just want to know the basics and the early chapters will provide those with the option of drilling down into details in the later chapters where some of the more complex concepts will be discussed in detail.

Kirk Haselden is the Group Program Manager for the Microsoft Master Data Management product forthcoming in the next wave of Office SharePoint Services and owns the long term strategy, vision, planning and development of that product. Kirk has been with Microsoft for 12 years in various groups including Hardware, eHome, Connected Home, SQL Server and Office Business Platform. He was the development manager for Integration Services and the primary designer for the runtime and many of the tasks. Prior to Microsoft, Kirk worked for several small startup companies building educational, dental and online software. Kirk has a BA in Accounting and Information Systems from the University of Utah. He has written a number of articles for SQL Server Magazine, speaks regularly at industry events, writes profusely on his personal and MSDN blog, and holds 35 patents or patents pending. Kirk is married and the father of five wonderful children. He enjoys family time, photography, snow skiing, wake boarding, racquetball, motorcycle riding, hiking, breathing, drinking, and eating. He’s always wearing hideous Hawaiian shirts, shorts, and sandals, except in the winter, when he also wears socks. He once lived in Wichita, Kansas and thinks it’s funny when people talk about themselves in third person.

Contents at a Glance
Part I: Getting Started
   1   Welcome to SQL Server Integration Services 2005   3
   2   Setting Up Integration Services   9
   3   Migrating from DTS   19
   4   Building a Package—Quick Start   35
Part II: Integration Services Basics and Concepts
   5   The Business Intelligence Development Studio   55
   6   The Building Blocks of Integration Services   103
   7   Grouping Control Flow with Containers   113
Part III: Control Flow Services
   8   The Stock Tasks   139
   9   Using Expressions   191
   10   The Stock Connection Managers   205
   11   Logging and the Stock Log Providers   243
   12   The Venerable Variable   261
   13   Looping and Foreach Enumerators   275
Part IV: Management Services
   14   Configuring and Deploying Solutions   299
   15   Using The Script Task   331
   16   Using Source Control   353
   17   SQL Server Management Studio   367
   18   Securing Packages   389
Part V: The Data Flow Task
   19   Introducing the Data Flow Task   415
   20   The Stock Data Flow Components   423
   21   Using the Script Component   489
   22   Advanced Data Flow Transformations   507
   23   Data Flow Task Internals and Tuning   537
Part VI: Programming Integration Services
   24   Building Custom Tasks   563
   25   Building Custom Data Flow Components   621
       Index   661

Erscheint lt. Verlag	3.8.2006
Verlagsort	Indianapolis
Sprache	englisch
Maße	232 x 178 mm
Gewicht	1352 g
Themenwelt	Informatik ► Datenbanken ► SQL Server
Themenwelt	Mathematik / Informatik ► Informatik ► Software Entwicklung
ISBN-10	0-672-32781-3 / 0672327813
ISBN-13	978-0-672-32781-0 / 9780672327810
Zustand	Neuware