book

Professional SQL Server® 2008 Integration Services

Name: Professional SQL Server® 2008 Integration Services
ISBN: 9780470247952

by Brian Knight, Erik Veerman, Grant Dickinson, Douglas Hinson, Darren Herbold

October 2008

Intermediate to advanced

1005 pages

27h 22m

English

Wrox

Read now

Unlock full access

Copyright
About the Authors
Credits
Acknowledgments
Introduction
Who This Book Is ForWhat This Book CoversHow This Book Is StructuredWhat You Need to Use This BookConventionsSource CodeErratap2p.wrox.com
1. Welcome to SQL Server Integration Services
1.1. SQL Server SSIS Historical Overview1.2. What's New in SSIS1.3. Getting Started1.3.1. Import and Export Wizard1.3.2. The Business Intelligence Development Studio1.4. Architecture1.4.1. Packages1.4.2. Tasks1.4.3. Data Source Elements1.4.4. Data Source Views1.5. Precedence Constraints1.5.1. Constraint Value1.5.2. Conditional Expressions1.6. Containers1.7. Variables1.8. Data Flow Elements1.8.1. Sources1.8.2. Destinations1.8.3. Transformations1.9. Error Handling and Logging1.10. Editions of SQL Server1.11. Summary
2. The SSIS Tools
2.1. Import and Export Wizard2.2. Business Intelligence Development Studio2.3. Creating Your First Package2.4. The Solution Explorer Window2.4.1. The Toolbox2.4.2. The Properties Windows2.4.3. Navigation Pane2.4.4. Other Windows2.5. The SSIS Package Designer2.5.1. Control Flow2.5.1.1. Task Grouping2.5.1.2. Annotation2.5.2. Connection Managers2.5.3. Variables2.5.4. Data Flow2.5.5. Event Handlers2.5.6. Package Explorer2.5.7. Executing a Package2.6. Package Installation Wizard2.7. Management Studio2.8. Summary
3. SSIS Tasks
3.1. SSIS Task Objects3.1.1. Using the Task Editor3.1.2. The Task Editor Expressions Tab3.1.3. Execution Results3.1.4. Common Properties3.2. Looping and Sequence Tasks3.3. Scripting Tasks3.3.1. ActiveX Script Task3.3.2. Script Task (.NET)3.4. Analysis Services Tasks3.4.1. Analysis Services Execute DDL Task3.4.2. Analysis Services Processing Task3.4.3. Data Mining Query Task3.5. Data Flow Task3.6. Data Preparation Tasks3.6.1. Data Profiler3.6.2. File System Task3.6.2.1. Archiving a File3.6.3. FTP Task3.6.3.1. Getting a File Using FTP3.6.4. Web Service Task3.6.4.1. Retrieving Data Using the Web Service Task and XML Source Component3.6.5. XML Task3.6.5.1. Validating an XML File3.7. RDBMS Server Tasks3.7.1. Bulk Insert Task3.7.1.1. Using the Bulk Insert Task3.7.2. Execute SQL Task3.7.2.1. Executing a Parameterized SQL Statement3.7.2.2. Executing a Batch of SQL Statements3.7.2.3. Capturing Singleton Results3.7.2.4. Multi-Row Results3.7.2.5. Executing a Stored Procedure3.7.2.6. Retrieving Output Parameters from a Stored Procedure3.8. Workflow Tasks3.8.1. Execute Package Task3.8.1.1. Setting Up Child Packages to Use Parent Variables3.8.1.2. Changing Parent Variables in Child Packages3.8.2. Execute Process Task3.8.3. Message Queue Task3.8.4. Send Mail Task3.8.5. WMI Data Reader Task3.8.6. WMI Event Watcher Task3.8.6.1. Polling a Directory for the Delivery of a File3.9. SMO Administration Tasks3.9.1. Transfer Database Task3.9.2. Transfer Error Messages3.9.3. Transfer Logins Task3.9.4. Transfer Master Stored Procedures Task3.9.5. Transfer Jobs Task3.9.6. Transfer SQL Server Objects Task3.10. Summary
4. Containers
4.1. Task Host Containers4.2. Sequence Containers4.3. Groups4.4. For Loop Container4.5. Foreach Loop Container4.5.1. Foreach File Enumerator Example4.5.2. Foreach ADO Enumerator Example4.6. Summary
5. The Data Flow
5.1. The Data Flow5.2. Data Viewers5.3. Sources5.3.1. OLE DB Source5.3.2. Excel Source5.3.3. Flat File Source5.3.3.1. FastParse Option5.3.3.2. MultiFlatFile Connection Managers5.3.4. Raw File Source5.3.5. XML Source5.3.6. ADO.NET Source5.4. Destinations5.4.1. Data Mining Model Training5.4.2. DataReader Destination5.4.3. Dimension and Partition Processing5.4.4. Excel Destination5.4.5. Flat File Destination5.4.6. OLE DB Destination5.4.7. Raw File Destination5.4.8. Recordset Destination5.4.9. SQL Server and Mobile Destinations5.5. Transformations5.5.1. Synchronous versus Asynchronous Transformations5.5.2. Aggregate5.5.3. Audit5.5.4. Cache Transform5.5.5. Character Map5.5.6. Conditional Split5.5.7. Copy Column5.5.8. Data Conversion5.5.9. Data Mining Query5.5.10. Derived Column5.5.11. Export Column5.5.12. Fuzzy Lookup5.5.13. Fuzzy Grouping5.5.14. Import Column5.5.15. Lookup Transform5.5.16. Merge Transform5.5.17. Merge Join5.5.18. Multicast5.5.19. OLE DB Command5.5.20. Percentage and Row Sampling5.5.21. Pivot Transform5.5.22. Unpivot5.5.23. Row Count5.5.24. Script Component5.5.25. Slowly Changing Dimension5.5.26. Sort5.5.27. Term Extraction5.5.28. Term Lookup5.5.29. Union All5.6. Data Flow Example5.7. Summary

6. Using Expressions and Variables
6.1. The Paradigm6.1.1. Expression Overview6.1.2. Variable Overview6.2. Understanding Data Types6.2.1. SSIS Data Types6.2.2. Additional Date and Time Type Support6.2.3. Wrong Data Types and Sizes Can Affect Performance6.2.4. Unicode and Non-Unicode Conversion Issues6.2.5. Casting in SSIS Expressions6.3. Using Variables6.3.1. Defining Variables6.3.2. Variable Data Types6.4. Working with Expressions6.4.1. C#-Like? Close, but Not Completely6.4.2. The Expression Builder6.4.3. Syntax Basics6.4.3.1. Equivalence Operator6.4.3.2. String Concatenation6.4.3.3. Line Continuation6.4.3.4. Literals6.4.3.4.1. Numeric Literals6.4.3.4.2. String Literals6.4.3.4.3. Boolean Literals6.4.3.5. Referencing Variables6.4.3.6. Referencing Columns6.4.3.7. Boolean Expressions6.4.3.8. Dealing with NULLs6.4.3.8.1. NULLs and Variables6.4.3.8.2. NULLs in Data Flow6.4.3.9. String Functions6.4.3.10. Conditional Expressions6.4.3.11. Date Time Functions6.4.4. Using Expressions in SSIS Packages6.4.4.1. Using Variables as Expressions6.4.4.2. Using Expressions in Properties of Connections6.4.4.3. Using Expressions in Control Flow Tasks6.4.4.4. Using Expressions in Control Flow Precedence6.4.4.5. Using Expressions in Data Flow6.5. Summary
7. Joining Data
7.1. The Lookup Component7.2. The Merge Join Component7.3. Contrasting to the Relational Join7.4. New Lookup Features7.5. Building the Basic Package7.5.1. Creating the Basic Package7.5.2. Using a Relational Join in the Source7.5.3. Using the Merge Join Component7.6. Using the Lookup Component7.6.1. Full-Cache Mode7.6.2. No-Cache Mode7.6.3. Partial-Cache Mode7.6.4. Multiple Outputs7.6.5. Expressionable Properties7.6.6. Cascaded Lookup Operations7.7. Cache Connection Manager and Transform7.8. Summary
8. Creating an End-to-End Package
8.1. Basic Transformation Tutorial8.1.1. Creating Connections8.1.2. Creating the Tasks8.1.3. Creating the Data Flow8.1.4. Completing the Package8.1.5. Saving the Package8.1.6. Executing the Package8.2. Typical Mainframe ETL with Data Scrubbing8.2.1. Creating the Data Flow8.2.2. Handling Dirty Data8.2.2.1. The Conditional Split Transformation8.2.2.2. The Lookup Transformation8.2.2.3. The Union All Transformation8.2.3. Finalizing8.2.4. Handling More Bad Data8.3. Looping and the Dynamic Task8.3.1. Looping8.3.2. Making the Package Dynamic8.4. Summary
9. Scripting in SSIS
9.1. Scripting?9.2. Getting Started in SSIS Scripting9.2.1. Selecting the Scripting Language9.2.2. Using the VSTA Scripting IDE9.2.3. Example: Hello World9.2.4. Adding Code and Classes9.2.5. Using Managed Assemblies9.2.5.1. Example: Using Custom .NET Assemblies9.3. Using the Script Task9.3.1. Configuring the Script Task Editor9.3.2. The Script Task Dts Object9.3.3. Accessing Variables in the Script Task9.3.3.1. Example: Using Script Task Variables to Control Package Flow9.3.4. Connecting to Data Sources in a Script Task9.3.4.1. Example: Retrieving Data into Variables from a Database9.3.4.2. Example: Saving Data to an XML File9.3.4.3. Example: Serializing Data to XML9.3.5. Raising an Event in a Script Task9.3.5.1. Example: Raise Some Events9.3.5.2. Example: Respond to an Event9.3.5.3. Example: Logging Event Information9.3.6. Writing a Log Entry in a Script Task9.3.6.1. Example: Script a Log Entry9.4. Using the Script Component9.4.1. Differences from a Script Task9.4.2. Configuring the Script Component Editor9.4.3. Accessing Variables in a Script Component9.4.4. Connecting to Data Sources in a Script Component9.4.5. Raising Events9.4.6. Logging9.4.6.1. Example: Script a Log Entry9.4.7. Example: Data Validation9.5. Essential Coding, Debugging, and Troubleshooting Techniques9.5.1. Structured Exception Handling9.5.2. Script Debugging and Troubleshooting9.5.2.1. Breakpoints9.5.2.2. Row Count and Data Viewers9.5.2.3. Autos, Locals, and Watches9.5.2.4. The Immediate Window9.6. Summary
10. Loading a Data Warehouse
10.1. Data Profiling10.1.1. Initial Execution of the Data Profiling Task10.1.2. Reviewing the Results of the Data Profiling Task10.1.3. Turning Data Profile Results into Actionable ETL Steps10.2. Data Extraction10.3. Dimension Table Loading10.3.1. Loading a Simple Dimension Table10.3.2. Loading a Complex Dimension Table10.3.2.1. Preparing the Data10.3.2.2. Handling Complicated Dimension Changes with the SCD Transformation10.3.3. Considerations and Alternates to the SCD Transformation10.4. Fact Table Loading10.5. SSAS Processing10.6. Master ETL Package10.7. Summary
11. Using the Relational Engine
11.1. Data Extraction11.1.1. SELECT * Is Bad11.1.2. WHERE Is Your Friend11.1.3. Transform during Extract11.1.4. Many ANDs Make Light Work11.1.5. SORT in the Database11.1.6. Modularize11.1.7. SQL Server Does Text Files Too11.1.8. Use Set-Based Logic11.2. SQL Server 2008 Change Data Capture11.2.1. Benefits of SQL Server 2008 CDC11.2.2. Preparation11.2.3. Capture Instance Tables11.2.4. The CDC API11.2.5. Using CDC from within SSIS11.3. Data Loading11.3.1. Database Snapshots11.3.2. The MERGE Operator11.4. Summary
12. Accessing Heterogeneous Data
12.1. Excel and Access12.1.1. Limited 64-Bit Support12.1.2. Working with Excel Files12.1.3. Access12.1.3.1. Understanding Access Security12.1.3.2. Configuring an Access Connection Manager12.1.3.3. Importing from Access12.1.3.4. Using a Parameter12.2. Oracle12.2.1. Oracle Client Setup12.2.1.1. Installing the Oracle Client Software12.2.1.2. Configuring the Oracle Client Software12.2.1.3. 64-Bit Considerations12.2.2. Importing Oracle Data12.3. XML and Web Services12.3.1. Configuring the Web Service Task12.3.1.1. Weather by ZIP Code Example12.3.1.2. The Currency Conversion Example12.3.2. Working with XML Data as a Source12.4. Flat Files12.4.1. Loading Flat Files12.4.2. Extracting Data from Flat Files12.5. ODBC12.6. Other Heterogeneous Sources12.7. Summary
13. Reliability and Scalability
13.1. Restarting Packages13.1.1. Simple Control Flow13.1.2. Containers within Containers and Checkpoints13.1.3. Variations on a Theme13.1.3.1. Failing the Parent, Not the Package13.1.3.2. Failing the Parent and the Package13.1.3.3. Failing the Task with No Transaction13.1.3.4. Failing the Package, Not the Sequence13.1.4. Inside the Checkpoint File13.2. Package Transactions13.2.1. Single Package, Single Transaction13.2.2. Single Package, Multiple Transactions13.2.3. Two Packages, One Transaction13.2.4. Single Package Using a Native Transaction in SQL Server13.3. Error Outputs13.4. Scaling Out13.4.1. Architectural Improvements13.4.1.1. Lookup Transformation Improvements13.4.1.2. Data Pipeline Improvements13.4.2. Scale Out Memory Pressures13.4.3. Scale Out by Staging Data13.4.3.1. Data Flow Restart13.4.3.2. Scale across Machines13.5. Summary
14. Understanding and Tuning the Data Flow Engine
14.1. The SSIS Engine14.1.1. Understanding the SSIS Data Flow and Control Flow14.1.1.1. Comparing and Contrasting the Data Flow and Control Flow14.1.1.2. SSIS Package Execution Times from Package Start to Package Finish14.1.2. Handling Workflows with the Control Flow14.1.3. Data Processing in the Data Flow14.1.4. Memory Buffer Architecture14.1.5. Types of Transformations14.1.5.1. Non-Blocking, Semi-Blocking, and Blocking14.1.5.1.1. Non-Blocking Transformations, Streaming and Row-Based14.1.5.1.2. Semi-Blocking Transformations14.1.5.1.3. Blocking Transformations14.1.5.2. Synchronous and Asynchronous Transformation Outputs14.1.5.2.1. Asynchronous Transformation Outputs14.1.5.2.2. Synchronous Transformation Outputs14.1.5.3. Source and Destination Adapters14.1.6. Advanced Data Flow Execution Concepts14.1.6.1. Execution Trees14.1.6.2. Monitoring Data Flow Execution14.1.6.2.1. Pipeline Execution Tree Log Details14.1.6.2.2. Pipeline Execution Plan Log Details14.2. SSIS Data Flow Design and Tuning14.2.1. Data Flow Design Practices14.2.1.1. Leveraging the Data Flow14.2.1.2. Data Integration and Correlation14.2.1.3. Data Cleansing and Transformation14.2.1.4. Staging Environments14.2.2. Optimizing Package Processing14.2.2.1. Optimizing Buffers, Execution Trees, and Engine Threads14.2.2.2. Careful Use of Row-Based Transformations14.2.2.3. Understand Blocking Transformation Impacts14.2.3. Troubleshooting Data Flow Performance Bottlenecks14.3. Pipeline Performance Monitoring14.4. Summary
15. Source Control and Software Development Life Cycle
15.1. Introduction to Software Development Life Cycles15.1.1. Software Development Life Cycles: A Brief History15.1.2. Types of Software Development Life Cycles15.1.2.1. Waterfall SDLCs15.1.2.2. Iterative SDLCs15.2. Versioning and Source Code Control15.2.1. Microsoft Visual SourceSafe15.2.2. Team Foundation Server, Team System, and SSIS15.2.3. MSF Agile and SSIS15.2.3.1. Work Items15.2.3.2. Documents15.2.3.3. Reports15.2.4. The Project Portal15.2.5. Putting It to Work15.2.5.1. Version and Source Control with Team System15.2.5.2. Shelving and Unshelving15.2.5.3. Branching15.2.5.4. Merging15.2.5.5. Labeling (Striping) Source Versions15.3. Code Deployment and Promotion from Development to Test to Production15.3.1. The Deployment Wizard15.3.2. Import a Package15.4. Summary
16. DTS 2000 Migration
16.1. Managing DTS 2000 Packages within SQL Server Management Studio16.2. Running DTS 2000 Packages under SSIS16.3. Migrating DTS 2000 Packages to SSIS16.4. Using the Package Migration Wizard16.5. Third-Party Migration Solution16.6. Summary
17. Error and Event Handling
17.1. Precedence Constraint17.1.1. Precedence Constraint Basics17.1.2. Advanced Precedence Constraints and Expressions17.1.2.1. Using Boolean Expressions with Precedence Constraints17.1.2.2. Working with Multiple Precedence Constraints17.2. Event Handling17.2.1. Events17.2.2. Inventory Example17.2.2.1. Using the OnError Event Handler Event17.2.2.2. Using the OnPreExecute Event Handler Event17.2.3. Event Handler Inheritance17.3. Breakpoints17.4. Error Rows17.5. Logging17.5.1. Logging Providers17.5.2. Log Events17.6. Summary
18. Programming and Extending SSIS
18.1. The Sample Components18.1.1. Component 1: Source Adapter18.1.2. Component 2: Transformation18.1.3. Component 3: Destination Adapter18.2. The Pipeline Component Methods18.2.1. Design-Time Functionality18.2.1.1. ProvideComponentProperties18.2.1.2. Validate18.2.1.3. ReinitializeMetaData18.2.1.4. MapInputColumn and MapOutputColumn18.2.1.5. Input and Output Verification Methods18.2.1.6. Set Column Data Types18.2.1.7. PerformUpgrade18.2.1.8. RegisterEvents18.2.1.9. RegisterLogEntries18.2.1.10. SetComponentProperty18.2.1.11. Set Column Properties18.2.1.12. SetUsageType18.2.1.13. On Path Attachment18.2.2. Runtime18.2.2.1. PrepareForExecute18.2.2.2. PreExecute18.2.2.3. PrimeOutput and ProcessInput18.2.2.4. PostExecute18.2.2.5. Cleanup18.2.2.6. DescribeRedirectedErrorCode18.2.3. Connection Time18.2.3.1. AcquireConnections18.2.3.2. ReleaseConnections18.3. Building the Components18.3.1. Preparation18.3.2. Building the Source Component18.3.3. Building the Transform Component18.3.4. Building the Destination Adapter18.4. Using the Components18.4.1. Installing the Components18.4.2. Debugging Components18.4.3. Design-Time18.4.4. Building the Complete Package18.4.5. Runtime Debugging18.5. Upgrading to SQL 200818.6. Summary
19. Adding a User Interface to Your Component
19.1. Three Key Steps19.2. Building the User Interface19.2.1. Adding the Project19.2.2. Implementing IDtsComponentUI19.2.2.1. IDtsComponentUI.Delete19.2.2.2. IDtsComponentUI.Help19.2.2.3. DtsComponentUI.New19.2.2.4. IDtsComponentUI.Initialize19.2.2.5. IDtsComponentUI.Edit19.2.3. Setting the UITypeName19.2.4. Building the Form19.2.4.1. Form Constructor19.2.4.2. Column Display19.2.4.3. Column Selection19.3. Further Development19.3.1. Runtime Connections19.3.2. Component Properties19.3.3. Handling Errors and Warnings19.3.4. Column Properties19.4. Other Considerations19.5. Summary
20. External Management and WMI Task Implementation
20.1. External Management of SSIS with Managed Code20.1.1. Setting Up a Test SSIS Package for Demonstration Purposes20.1.2. The DTS Runtime Managed Code Library20.2. Application Object Maintenance Operations20.2.1. Package Maintenance Operations20.2.1.1. A Package Maintenance Example20.2.1.2. A Package Transfer Example20.2.2. Package Folder Maintenance20.2.3. Package Role Maintenance20.2.4. Package Monitoring20.2.5. Package Listing20.2.6. A Package Management Example20.3. Package Log Providers20.3.1. Specifying Events to Log20.3.2. Programming to Log Providers20.4. Package Configurations20.4.1. Creating a Configuration20.4.2. Programming the Configuration Object20.4.3. Configuration Object20.5. Windows Management Instrumentation Tasks20.5.1. WMI Reader Task Explained20.5.2. WMI Data Reader Example20.5.3. WMI Event Watcher Task20.5.4. WMI Event Watcher Task Example20.6. Summary
21. Using SSIS with External Applications
21.1. InfoPath Documents21.2. ASP.NET Applications21.3. Winform .NET Applications21.4. Summary
22. Administering SSIS
22.1. Package Configuration22.2. Deployment Utility22.2.1. Creating the Deployment Manifest22.2.2. The Package Deployment Wizard22.3. The Package Store22.3.1. Creating a Central SSIS Server22.3.2. Clustering SSIS22.3.3. File System or the MSDB Deployment22.4. Management Studio22.5. Running Packages with DTExecUI22.6. Security22.7. Command-Line Utilities22.7.1. DTExec22.7.2. DTUtil22.7.2.1. Re-Encrypting All Packages in a Directory22.7.2.2. Handling a Corrupt Package22.8. Scheduling a Package22.9. Proxy Accounts22.10. 64-Bit Issues22.11. Performance Counters22.12. Summary
23. Case Study: A Programmatic Example
23.1. What You Will Take Away23.2. Background23.3. Business Problem23.4. Solution Summary23.5. Solution Architecture23.5.1. Naming Conventions and Tips23.5.2. Additional SSIS Tips Before You Start a Large Project23.6. Data Architecture23.6.1. File Storage Location Setup23.6.2. Bank ACH Payments23.6.3. Lockbox Files23.6.4. PayPal or Direct Credits to Corporate Account23.6.5. Case Study Database Model23.6.6. Database Setup23.6.6.1. Customer23.6.6.2. Invoice23.6.6.3. CustomerLookUp23.6.6.4. BankBatch23.6.6.5. BankBatchDetail23.6.6.6. Corporate Ledger Data23.6.6.7. ErrorDetail23.6.6.8. Stored Procedure to Add Batches23.6.6.9. Stored Procedure to Update a Batch with Invoice and Customer Id23.6.6.10. Stored Procedure to Balance a Batch23.7. Case Study Load Packages23.7.1. Bank File Load Package23.7.1.1. Bank File Package and Variable Setup Tasks23.7.1.2. Bank File Control Flow Processing23.7.1.2.1. Bank File Control Flow File Loop23.7.1.2.2. Bank File Control Flow Retrieval of File Properties23.7.1.2.3. Bank File Control Flow Batch Creation23.7.1.3. Bank File Data Flow Validation23.7.1.3.1. Bank File Data Flow Parsing and Error Handling23.7.1.3.2. Bank File Data Flow Validation23.7.1.3.3. Bank File Data Flow Capturing Total Batch Items23.7.1.4. Bank File Data Flow Detail Processing ETL23.7.1.4.1. Processing the Bank File Check and Invoice Detail Lines23.7.1.4.2. Saving a Bank File Snapshot in the Database23.7.2. ACH Load Package23.7.2.1. ACH Package Setup and File System Tasks23.7.2.2. ACH Control Flow Processing23.7.2.2.1. ACH Control Flow Loop23.7.2.2.2. ACH Control Flow Retrieval of XML File Size23.7.2.2.3. ACH Control Flow Batch Creation23.7.2.3. ACH Data Flow Validation23.7.2.3.1. ACH Data Flow Parsing and Error Handling23.7.2.3.2. ACH Data Flow Validation23.7.2.3.3. ACH Data Flow Capturing Total Batch Items23.7.2.4. ACH Data Flow Detail Processing ETL23.7.2.4.1. Processing the ACH File23.7.2.4.2. Saving the ACH File Snapshot in the Database23.7.3. Email Load Package23.7.3.1. Email Package Setup and File System Tasks23.7.3.2. Email Control Flow Processing23.7.3.3. Email Data Flow Processing23.7.4. Testing23.8. Case Study Invoice Matching Process23.8.1. Matching Process Control Flow23.8.1.1. Matching Process Package Setup23.8.1.2. Add the Matching Process Logic23.8.2. Matching Process High-Confidence Data Flow23.8.3. Matching Process Medium-Confidence Data Flow23.8.4. Interpreting the Results23.9. Creating a Parent Driver Package23.9.1. Driver Package Setup23.9.2. Driver Package Deployment23.10. Summary

Overview

The new edition of the successful previous version is 25 percent revised and packed with more than 200 pages of new material on the 2008 release of SQL Server Integration Services (SSIS)
Renowned author Brian Knight and his expert coauthors show developers how to master the 2008 release of SSIS, which is both more powerful and more complex than ever
Case studies and tutorial examples acquired over the three years since the previous edition will contribute to helping illustrate advanced concepts and techniques
New chapters include coverage of data warehousing using SSIS, new methods for managing the SSIS platform, and improved techniques for ETL operations

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.

Julian F.

Head of Cybersecurity

I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.

Addison B.

Field Engineer

I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.

Amir M.

Data Platform Tech Lead

I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.

Mark W.

Embedded Software Engineer

Professional SQL Server™ 2005 Integration Services

Publisher Resources

ISBN: 9780470247952Purchase book

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills