|
![]() |
|||
|
||||
OverviewAll 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. Full Product DetailsAuthor: Kirk Haselden , Kirk HaseldenPublisher: Pearson Education (US) Imprint: Sams Publishing Dimensions: Width: 23.20cm , Height: 4.10cm , Length: 17.80cm Weight: 1.352kg ISBN: 9780672327810ISBN 10: 0672327813 Pages: 744 Publication Date: 03 August 2006 Audience: College/higher education , Tertiary & Higher Education Format: Paperback Publisher's Status: Out of Print Availability: In Print ![]() Limited stock is available. It will be ordered for you and shipped pending supplier's limited stock. Table of ContentsContents 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 661ReviewsAuthor InformationKirk 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. Tab Content 6Author Website:Countries AvailableAll regions |