SQL Server Integration Services(SSIS)

Course Content:

  • Database
  • OLTP vs OLAP
  • Basics of Data warehousing
  • Introduction to SQL Server Integration Services
  • SSIS Historical Overview
  • SSIS Architecture
  • Tools of the Trade
  • Creating a Simple Package
  • Flows-Control flow, Data Flow
  • SSIS Tasks
  • Working with Containers
  • Using Variables, Parameters and Expressions
  • The Data Flow
  • Understanding the Data Flow
  • Sources & Destinations
  • Common Transformations
  • Accessing Heterogeneous Data
  • The Connection Managers
  • Excel
  • Oracle
  • Using XML and Web Services
  • Flat Files
  • Other Heterogeneous Sources
  • Error and Event Handling
  • Package Transactions
  • Using Precedence Constraints
  • Event Handling
  • Breakpoints
  • Error Rows
  • Logging
  • SSIS Administration
  • Deployment Models
  • Package Configuration
  • Security
  • Scheduling Packages
  • Monitoring Package Executions
  • Practice

(c) 2013 Sakthi Software Solutions Pvt.Ltd. All Rights Reserved