Table of Contents
Chapter 1: Moving Data with the Import and Export Wizard
Chapter 2: Installing SQL Server Integration Services
Chapter 3: Installing the Sample Databases
Chapter 4: Creating a Solution and Project
Chapter 5: Exploring SQL Server Data Tools
Chapter 6: Creating Your First Package
Creating and Using Connection Managers
Chapter 7: Upgrading Packages to SQL Server 2012
Chapter 8: Upgrading to the Project Deployment Model
Chapter 9: Using Precedence Constraints
Chapter 10: Manipulating Files with the File System Task
Chapter 11: Coding Custom Script Tasks
Chapter 12: Using the Execute SQL Task
Chapter 13: Using the Execute Process Task
Chapter 14: Using the Expression Task
Chapter 15: Using the Send Mail Task
Chapter 16: Using the FTP Task
Chapter 17: Creating a Data Flow
Chapter 18: Extracting Data from Sources
Chapter 19: Loading Data to a Destination
Chapter 20: Changing Data Types with the Data Conversion Transform
Chapter 21: Creating and Replacing Columns with the Derived Column Transform
Chapter 22: Rolling Up Data with the Aggregate Transform
Chapter 23: Ordering Data with the Sort Transform
Chapter 24: Joining Data with the Lookup Transform
The Cache Connection Manager and Transform
Chapter 25: Auditing Data with the Row Count Transform
Chapter 26: Combining Multiple Inputs with the Union All Transform
Chapter 27: Cleansing Data with the Script Component
Chapter 28: Separating Data with the Conditional Split Transform
Chapter 29: Altering Rows with the OLE DB Command Transform
Chapter 30: Handling Bad Data with the Fuzzy Lookup
Chapter 31: Removing Duplicates with the Fuzzy Grouping Transform
Chapter 32: Making a Package Dynamic with Variables
Chapter 33: Making a Package Dynamic with Parameters
Chapter 34: Making a Connection Dynamic with Expressions
Chapter 35: Making a Task Dynamic with Expressions
Chapter 36: Loading Data Incrementally
Chapter 37: Using the CDC Components in SSIS
Chapter 38: Using Data Quality Services
Chapter 39: Using the DQS Cleansing Transform
Chapter 40: Creating a Master Package
Chapter 41: Using Sequence Containers to Organize a Package
Chapter 42: Using For Loop Containers to Repeat Control Flow Tasks
Chapter 43: Using the Foreach Loop Container to Loop Through a Collection of Objects
Chapter 44: Easing Deployment with Configuration Tables
Chapter 45: Easing Deployment with Configuration Files
Chapter 46: Configuring Child Packages
Configuring an Execute Package Task
Chapter 47: Logging Package Data
Chapter 48: Using Event Handlers
Common Uses for Event Handlers
Chapter 49: Troubleshooting Errors
Chapter 50: Using Data Viewers
Chapter 52: Creating and Configuring the SSIS Catalog
Chapter 53: Deploying Packages to the Package Catalog
Deploying Packages in the Package Deployment Model
Chapter 54: Configuring the Packages
Chapter 55: Configuring the Service
Chapter 56: Securing SSIS Packages
Securing Packages in the Package Deployment Model
Securing Packages in the Project Deployment Model
Chapter 57: Running SSIS Packages
Executing Packages in the Package Deployment Model
Running Packages in the Project Deployment Model
Chapter 58: Running Packages in T-SQL and Debugging Packages
Debugging When Something Goes Wrong
Chapter 59: Scheduling Packages
Chapter 62: Bringing It All Together
Appendix A: SSIS Component Crib Notes
When to Use Control Flow Tasks
When to Use Data Flow Transforms
Appendix B: Problem and Solution Crib Notes