Introduction to SQL Server 2014 Integration Services (SSIS)

Introduction to SQL Server 2014 Integration Services (SSIS)

 

Bascom Bridge’s Introduction to SQL Server 2014 Integration Services (SSIS) training teaches attendees how to use SSIS to build high performance ETL (Extract, Transform, and Load) and workflow packages and projects.

 

SSIS TRAINING OBJECTIVES

All students will:

  • Create sophisticated SSIS packages for extracting, transforming, and loading data
  • Use containers to efficiently control repetitive tasks and transactions
  • Configure packages to dynamically adapt to environment changes
  • Use Data Quality Services to cleanse data
  • Incrementally load data into a data warehouse
  • Deploy and execute packages
  • Successfully troubleshoot packages
  • Configure package reliability

SSIS TRAINING PREREQUISITES

All attendees should have prior experience working with SQL Server 2014. Some basic programming background is helpful, but not required.

SSIS TRAINING MATERIALS

All students receive a copy of Wrox Press’s Professional SQL Server 2014 Integration Services.

SOFTWARE NEEDED FOR EACH PC:

  • At least 6 GB RAM
  • At least 10 GB free disk space
  • 64-bit Windows 7 or later, or Windows Server 2012 or later, with the latest service pack updates.
  • A full installation of SQL Server 2014 (server and client tools), including Integration Services, with the latest service packs applied
    • Use SQL Server Developer Edition on Windows 7 or 8, or Enterprise Edition on Windows Server operating systems
  • Excel 2007 or later with the latest service packs installed
  • SSDT-BI for Visual Studio 2013
  • An accessible SMTP server or forwarder (and optionally Outlook or another email client)
  • Related sample databases and lab files that Accelebrate will provide
  • If you have purchased this course, please contact us for detailed setup instructions.
  • For classes delivered online, all participants need either dual monitors or a separate device logged into the online session so that they can do their work on one screen and watch the instructor on the other. A separate computer connected to a projector or large screen TV would be another way for students to see the instructor’s screen simultaneously with working on their own.

SSIS TRAINING OUTLINE

  • The Big Picture
    • Microsoft Business Intelligence Suite
    • The SSIS Architecture
    • Import/Export Wizard
    • Introducing SSDT-BI
  • Control Flow
    • Introduction to the Control Flow
    • Understanding Precedent Constraints
    • Grouping and Annotating Tasks
    • Working with Properties
    • Favorite Tasks
    • Common Tasks
  • Data Flow Sources and Destinations
    • Working with Data Sources
    • Working with Data Destinations
  • Data Flow Transformations
    • Basic Transformations
    • Blocking Transformations
    • Advanced Transformations
    • Managing Incremental Updates
  • Making packages dynamic
    • Using Variables
    • Understanding Package Parameters
    • Understanding Project Parameters
    • Working with Expressions
  • Containers and Advanced Control Flow Tasks
    • Working with Containers
    • Adding Custom Control Flow Tasks
    • The “Other Tasks”
    • Instructor Demonstration of “Other Tasks”
    • Working with Change Data Capture (CDC)
  • Package Reliability
    • Configuring Logging
    • Creating Event Handlers
    • Redirecting Rows
    • Using Checkpoints
    • Configuring Transactions
  • Advanced Scripting
    • General SSIS Programming Overview
    • Creating Custom Event Handlers
    • Writing Custom Transformations
    • Advanced Script Tasks
  • Deploying to the SSIS Catalog
    • Introduction to the SSIS Catalog
    • Creating Environments
    • Deploying Projects
    • Backwards Compatibility
    • Executing Packages in SQL Server Management Studio (SSMS)
    • Executing Packages from the Command Line
  • Working with Data Quality Services (If Time Permits)
    • Installing and Configuring DQS
    • Building a DQS Knowledge Base and Domains
    • Using the DQS Cleansing Transformation
    • Reviewing DQS Output
  • Conclusion

Send a Comment

Your email address will not be published.

CONTACT US

+91 9376007676  

INQUIRY NOW


,

Introduction to SQL Server 2014 Integration Services (SSIS)

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...
  • Course No : SQL-424
  •  Theory : 40%
  •  Lab : 60%
  • Duration : 24 hours
Scroll Up
Skip to toolbar