Introduction to SQL Server 2012 Integration Services (SSIS)

Introduction to SQL Server 2012 Integration Services (SSIS)

Bascom Bridge’s Introduction to SQL Server 2012 Integration Services training teaches attendees how to use SSIS to build high performance data integration solutions. SSIS training clients currently using DTS are encouraged to bring a package or two of reasonable size and complexity to class as a case study for porting a DTS package to SSIS.

 

SSIS TRAINING OBJECTIVES

  • Install SSIS 2012 (optional topic; class can be taught with SSIS already configured)
  • Create sophisticated SSIS packages for extracting, transforming, and loading data
  • Use Data Quality Services to cleanse data
  • Incrementally load data
  • Load a data warehouse
  • Roll up, order, join, audit, cleanse, and separate data
  • Administering and troubleshoot SSIS
  • Deploy, configure, and schedule packages

SSIS TRAINING PREREQUISITES

All SSIS 2012 training attendees should have prior experience working with SQL Server 2012.

SSIS TRAINING MATERIALS

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

SOFTWARE NEEDED FOR EACH PC:

  • At least 3GB RAM.
  • SQL Server 2012 Developer with 32- or 64-bit Windows Vista, 7, or 2008 with the latest service packs, or SQL Server 2012 Enterprise or Business Intelligence with Windows Server 2008 SP2 or R2. Please ensure Integration Services and Reporting Services are installed along with the database engine, and please ensure all client tools are installed.
  • Related sample databases and lab files that Accelebrate provides.
  • 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

  • Introduction
    • Import and Export Wizard
    • SQL Server Data Tools
    • Architecture
    • SSIS Capabilities Available in Editions of SQL Server 2012
  • Installation and Getting Started
    • Moving Data with the Import and Export Wizard
    • Installing SQL Server Integration Services
    • Installing the Sample Databases
    • Creating a Solution and Project
    • Exploring SQL Server Data Tools
    • Creating Your First Package
    • Upgrading Packages to SQL Server 2012
    • Upgrading to the Project Deployment Model
  • Control Flow
    • Using Precedence Constraints
    • Manipulating Files with the File System Task
    • Coding Custom Script Tasks
    • Using the Execute SQL Task
    • Using the Execute Process Task
    • Using the Expression Task
    • Using the Send Mail Task
    • Using the FTP Task
    • Creating a Data Flow
  • Data Flow
    • Extracting Data from Sources
    • Loading Data to a Destination
    • Changing Data Types with the Data Conversion Transform
    • Creating and Replacing Columns with the Derived Column Transform
    • Rolling Up Data with the Aggregate Transform
    • Ordering Data with the Sort Transform
    • Joining Data with the Lookup Transform
    • Auditing Data with the Row Count Transform
    • Combining Multiple Inputs with the Union All Transform
    • Cleansing Data with the Script Component
    • Separating Data with the Conditional Split Transform
    • Altering Rows with the OLE DB Command Transform
    • Handling Bad Data with the Fuzzy Lookup
    • Removing Duplicates with the Fuzzy Grouping Transform
  • Making Packages Dynamic
    • Making a Package Dynamic with Variables
    • Making a Package Dynamic with Parameters
    • Making a Connection Dynamic with Expressions
    • Making a Task Dynamic with Expressions
  • Common ETL Scenarios
    • Loading Data Incrementally
    • Using the CDC Components in SSIS
    • Using Data Quality Services
    • Using the DQS Cleansing Transform
    • Creating a Master Package
  • Containers
    • Using Sequence Containers to Organize a Package
    • Using For Loop Containers to Repeat Control Flow Tasks
    • Using the For Each Loop Container to Loop Through a Collection of Objects
  • Configuring Packages
    • Easing Deployment with Configuration Tables
    • Easing Deployment with Configuration Files
    • Configuring Child Packages
  • Troubleshooting SSIS
    • Logging Package Data
    • Using Event Handlers
    • Troubleshooting Errors
    • Using Data Viewers
    • Using Breakpoint
  • Administering SSIS
    • Creating and Configuring the SSIS Catalog
    • Deploying Packages to the Package Catalog
    • Configuring the Packages
    • Configuring the Service
    • Securing SSIS Packages
    • Running SSIS Packages
    • Running Packages in T-SQL and Debugging Packages
    • Scheduling Packages
  • Loading a Warehouse
    • Dimension Load
    • Fact Table Load
  • Wrap up and Review
    • Bringing it all Together
    • SSIS Component Crib Notes
    • Problem and Solution Crib Notes
  • Conclusion

Send a Comment

Your email address will not be published.

CONTACT US

+91 9376007676  

INQUIRY NOW


,

Introduction to SQL Server 2012 Integration Services (SSIS)

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