O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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