Microsoft SQL Server 2005 Integration Services
©2007 |Sams Publishing |
©2007 |Sams Publishing |
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, providing you with true enterprise extract transform and load features (ETL).
Microsoft SQL Server 2005 Integration Services concentrates on providing you with real world solutions to real world problems, giving you a head start on various projects. If you are only evaluating Integration Services, you'll be able to focus on the early chapters with the option of drilling down into details in the later chapters where some of the more complex concepts will be discussed in detail. The interesting sidebars peppered throughout the book provide insight into the processes, people and decisions that yielded the final IS product.
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
Pearson offers affordable and accessible purchase options to meet the needs of your students. Connect with us to learn more.
K12 Educators: Contact your Savvas Learning Company Account General Manager for purchase options. Instant Access ISBNs are for individuals purchasing with credit cards or PayPal.
Savvas Learning Company is a trademark of Savvas Learning Company LLC.
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.
We're sorry! We don't recognize your username or password. Please try again.
The work is protected by local and international copyright laws and is provided solely for the use of instructors in teaching their courses and assessing student learning.
You have successfully signed out and will be required to sign back in should you need to download more resources.