Synopses & Reviews
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
- 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 the Author
Paul Turley, Joe Kasprzak, Scott Cameron, Satoshi Iizuka, and Pablo Guzman are each business intelligence experts who work for Hitachi Consulting.
Table of Contents
Introduction; Finding Your Best Starting Point; About the Companion CD-ROM; System Requirements; Installing and Using the Sample Files; Conventions and Features in This Book; Getting Started with Integration Services; Chapter 1: Introduction to SQL Server Integration Services; 1.1 Common SSIS Applications; 1.2 SSIS Objects and Process Control Components; 1.3 SSIS Process Control; 1.4 SSIS Components; 1.5 SQL Server 2000 DTS Migration; 1.6 Chapter 1 Quick Reference; Chapter 2: Building Your First Package; 2.1 Exploring Business Intelligence Development Studio; 2.2 Using the SSIS Import and Export Wizard; 2.3 Reviewing Package Elements; 2.4 Testing a Package; 2.5 Chapter 2 Quick Reference; Designing Packages; Chapter 3: Extracting and Loading Data; 3.1 Connection Managers; 3.2 Using Data Sources and Data Source Views; 3.3 Chapter 3 Quick Reference; Chapter 4: Using Data Flow Transformations; 4.1 Creating Data Flow in a Package; 4.2 SSIS Transformations; 4.3 Using Expressions in Packages; 4.4 Using Data Flow Transformations; 4.5 Configuring Error Output; 4.6 Chapter 4 Quick Reference; Chapter 5: Managing Control Flow; 5.1 Control Flow Elements; 5.2 Chapter 5 Quick Reference; Chapter 6: Scripting Tasks; 6.1 Understanding Scripting Tasks; 6.2 Implementing a Script Task; 6.3 Understanding the Script Component; 6.4 Implementing the Script Component; 6.5 Understanding an ActiveX Script Task; 6.6 Chapter 6 Quick Reference; Chapter 7: Debugging Packages; 7.1 Debugging Control Flow; 7.2 Debugging Data Flow; 7.3 Debugging Script Task; 7.4 Chapter 7 Quick Reference; Chapter 8: Managing Package Execution; 8.1 Understanding Package Configurations; 8.2 Creating and Editing an XML Configuration File; 8.3 Multiple Configuration Files; 8.4 Using Configuration Files; 8.5 Creating Multiple Configuration Files; 8.6 Exploring Package Execution Options; 8.7 Understanding Package Logging; 8.8 Implementing Package Logging; 8.9 Chapter 8 Quick Reference; Managing Packages; Chapter 9: Detecting and Handling Processing Errors; 9.1 Basic Error Detection and Handling; 9.2 Understanding Event Handlers; 9.3 Creating Event Handlers; 9.4 Maintaining Data Consistency with Transactions; 9.5 Using Checkpoint Restarts; 9.6 Using Checkpoints and Transactions; 9.7 Chapter 9 Quick Reference; Chapter 10: Securing and Deploying SSIS Packages; 10.1 Creating a Deployment Utility; 10.2 Securing a Package; 10.3 Role-Based Security; 10.4 Deployment Options; 10.5 Creating and Applying a Configuration; 10.6 Executing a Deployed Package; 10.7 Monitoring Package Execution and Event Logs; 10.8 Chapter 10 Quick Reference; Chapter 11: Optimizing SSIS Packages; 11.1 SSIS Engine Overview; 11.2 Memory Buffer Architecture; 11.3 Execution Trees; 11.4 Synchronous and Asynchronous Processing; 11.5 Data Blocking; 11.6 Non-blocking Transformations; 11.7 Buffer Settings; 11.8 Managing Parallelism; 11.9 Data Source Tuning; 11.10 Performance Management; 11.11 Performance Management; 11.12 Iterative Design Optimization; 11.13 SSIS Log Reports; 11.14 Chapter 11 Quick Reference; Applying SSIS to Data Warehousing; Chapter 12: Data Warehouse Concepts; 12.1 Data Warehouse Objectives; 12.2 Data Warehouse Characteristics; 12.3 Data Warehouse Fundamentals; 12.4 Business Intelligence Solution Goals; 12.5 Focus on Decisions; 12.6 Data Granularity; 12.7 Update Frequency and Persistence; 12.8 Changing Dimensions; 12.9 Surrogate Keys; 12.10 Additive Measures; 12.11 Reviewing an Operational and Database Schema; 12.12 Data Warehouse System Components; 12.13 Reviewing and Comparing a Data Warehouse Database Schema; 12.14 Data Warehouse in Summary; 12.15 Chapter 12 Quick Reference; Chapter 13: Populating Data Warehouse Structures; 13.1 Data Warehouse Characteristics; 13.2 Implementing Staging Tables; 13.3 Types of Staging Schemes; 13.4 Managing Dimension Tables Part 1; 13.5 Managing Dimension Tables Part 2; 13.6 Slowly Changing Dimensions; 13.7 Managing Fact Tables; 13.8 Chapter 13 Quick Reference; Chapter 14: SSIS General Principles; 14.1 Designing SSIS Packages; 14.2 Chapter 14 Quick Reference; About the Authors; Paul Turley; Joe Kasprzak; Scott Cameron; Satoshi Iizuka; Pablo Guzman; Supporting Author - Anne Bockman Hansen; For Web Developers; Also See; Additional SQL Server Resources for Developers;