You are previewing Knight's Microsoft SQL Server 2012 Integration Services 24-Hour Trainer.
O'Reilly logo
Knight's Microsoft SQL Server 2012 Integration Services 24-Hour Trainer

Book Description

Book-and-video package gets novices up to speed on Microsoft SQL Server 2012

If you need a practical, hands-on introduction, especially to SQL Server Integration Services (SSIS), this book-and-video package from authority Brian Knight is the perfect solution. Each lesson includes three major components: a description of how each SSIS feature or process works, a tutorial that walks you through the process or technique, and an accompanying video lesson. It's a complete learning package that will give you the confidence you need to start your first SSIS project.

  • Guides novice database administrators and developers who are learning Microsoft SQL Server 2012 and SQL Server Integration Services (SSIS)

  • Provides expert instruction from leading SQL Server authority and author, Brian Knight

  • Includes a book and a video, complete instruction that includes lessons, hands-on tutorials, and video demonstrations by the author

  • Covers the very latest changes and updates in the SQL Server 2012 release

Microsoft SQL Server 2012 Integration Services 24-Hour Trainer makes SQL Server 2012 and SSIS much less intimidating.

Note: CD-ROM/DVD and other supplementary materials are not included as part of the e-book file, but are available for download after purchase.

Table of Contents

  1. Cover
  2. Contents
  3. Welcome to SISS
  4. Section 1
    1. Chapter 1: Moving Data with the Import and Export Wizard
      1. Try It
    2. Chapter 2: Installing SQL Server Integration Services
    3. Chapter 3: Installing the Sample Databases
      1. Try It
    4. Chapter 4: Creating a Solution and Project
      1. Try It
    5. Chapter 5: Exploring SQL Server Data Tools
      1. The Solution Explorer
      2. Deployment Models
      3. The Properties Window
      4. The Toolbox
      5. The SSDT Design Environment
    6. Chapter 6: Creating Your First Package
      1. Creating and Using Connection Managers
      2. Using and Configuring Tasks
      3. Exploring Package Encryption
      4. Executing Packages
      5. Try It
    7. Chapter 7: Upgrading Packages to SQL Server 2012
      1. Try It
    8. Chapter 8: Upgrading to the Project Deployment Model
      1. Try It
  5. Section 2
    1. Chapter 9: Using Precedence Constraints
      1. Try It
    2. Chapter 10: Manipulating Files with the File System Task
      1. Try It
    3. Chapter 11: Coding Custom Script Tasks
      1. Try It
    4. Chapter 12: Using the Execute SQL Task
      1. Try It
    5. Chapter 13: Using the Execute Process Task
      1. Try It
    6. Chapter 14: Using the Expression Task
      1. Try It
    7. Chapter 15: Using the Send Mail Task
      1. Try It
    8. Chapter 16: Using the FTP Task
      1. Try It
    9. Chapter 17: Creating a Data Flow
      1. Try It
  6. Section 3
    1. Chapter 18: Extracting Data from Sources
      1. Source Assistant
      2. OLE DB Source
      3. Excel Source
      4. Flat File Source
    2. Chapter 19: Loading Data to a Destination
      1. Destination Assistant
      2. OLE DB Destination
      3. Flat File Destination
      4. Excel Destination
    3. Chapter 20: Changing Data Types with the Data Conversion Transform
      1. Try It
    4. Chapter 21: Creating and Replacing Columns with the Derived Column Transform
      1. Try It
    5. Chapter 22: Rolling Up Data with the Aggregate Transform
      1. Try It
    6. Chapter 23: Ordering Data with the Sort Transform
      1. Try It
    7. Chapter 24: Joining Data with the Lookup Transform
      1. Cache Modes
      2. The Cache Connection Manager and Transform
    8. Chapter 25: Auditing Data with the Row Count Transform
      1. Try It
    9. Chapter 26: Combining Multiple Inputs with the Union All Transform
      1. Try It
    10. Chapter 27: Cleansing Data with the Script Component
      1. Try It
    11. Chapter 28: Separating Data with the Conditional Split Transform
      1. Try It
    12. Chapter 29: Altering Rows with the OLE DB Command Transform
      1. Try It
    13. Chapter 30: Handling Bad Data with the Fuzzy Lookup
      1. Try It
    14. Chapter 31: Removing Duplicates with the Fuzzy Grouping Transform
      1. Try It
  7. Section 4
    1. Chapter 32: Making a Package Dynamic with Variables
      1. Try It
    2. Chapter 33: Making a Package Dynamic with Parameters
      1. Try It
    3. Chapter 34: Making a Connection Dynamic with Expressions
      1. Try It
    4. Chapter 35: Making a Task Dynamic with Expressions
      1. Try It
  8. Section 5
    1. Chapter 36: Loading Data Incrementally
      1. Try It
    2. Chapter 37: Using the CDC Components in SSIS
      1. CDC Control Task
      2. CDC Source Task
      3. CDC Splitter Task
      4. Try It
    3. Chapter 38: Using Data Quality Services
      1. Try It
    4. Chapter 39: Using the DQS Cleansing Transform
      1. Try It
    5. Chapter 40: Creating a Master Package
      1. Try It
  9. Section 6
    1. Chapter 41: Using Sequence Containers to Organize a Package
      1. Try It
    2. Chapter 42: Using For Loop Containers to Repeat Control Flow Tasks
      1. Try It
    3. Chapter 43: Using the Foreach Loop Container to Loop Through a Collection of Objects
      1. Try It
  10. Section 7
    1. Chapter 44: Easing Deployment with Configuration Tables
      1. Try It
      2. Final Deployment
    2. Chapter 45: Easing Deployment with Configuration Files
      1. Try It
      2. Final Deployment
    3. Chapter 46: Configuring Child Packages
      1. Configuring an Execute Package Task
      2. Configuring a Child Package
      3. Try It
  11. Section 8
    1. Chapter 47: Logging Package Data
      1. Try It
    2. Chapter 48: Using Event Handlers
      1. Creating Event Handlers
      2. Common Uses for Event Handlers
      3. Try It
    3. Chapter 49: Troubleshooting Errors
      1. Working in the Progress Tab
      2. Troubleshooting Steps
      3. Try It
    4. Chapter 50: Using Data Viewers
      1. Try It
    5. Chapter 51: Using Breakpoints
      1. Try It
  12. Section 9
    1. Chapter 52: Creating and Configuring the SSIS Catalog
      1. Creating the Catalog
      2. Configuring the Catalog
      3. Creating and Using Folders
      4. Try It
    2. Chapter 53: Deploying Packages to the Package Catalog
      1. Using the Deployment Wizard
      2. Deploying Packages in the Package Deployment Model
      3. Try It
    3. Chapter 54: Configuring the Packages
      1. Creating Environments
      2. Configuring the Package
      3. Try It
    4. Chapter 55: Configuring the Service
      1. Try It
    5. Chapter 56: Securing SSIS Packages
      1. Securing Packages in the Package Deployment Model
      2. Securing Packages in the Project Deployment Model
      3. Try It
    6. Chapter 57: Running SSIS Packages
      1. Executing Packages in the Package Deployment Model
      2. Running Packages in the Project Deployment Model
      3. Try It
    7. Chapter 58: Running Packages in T-SQL and Debugging Packages
      1. Running the Package
      2. Debugging When Something Goes Wrong
      3. Try It
    8. Chapter 59: Scheduling Packages
      1. Using Proxy Accounts
      2. Try It
  13. Section 10
    1. Chapter 60: Dimension Load
      1. Try It
    2. Chapter 61: Fact Table Load
      1. Try It
  14. Section 11
    1. Chapter 62: Bringing It All Together
      1. Lesson Requirements
      2. Hints
      3. Step-by-Step
    2. Appendix A: SSIS Component Crib Notes
      1. When to Use Control Flow Tasks
      2. When to Use Data Flow Transforms
    3. Appendix B: Problem and Solution Crib Notes
  15. Appendix C: What's on the DVD?
    1. System Requirements
    2. Using the DVD
    3. What’s on the DVD
    4. Troubleshooting
    5. Customer Care
  16. Preface
  17. John Wiley & Sons, Inc. End-User License Agreement
  18. Advertisement