SSIS (SQL Server Integration Services)

Through this course you will learn features to? the Structured Query Language (SQL) including transaction control, exception and error handling, row processing and declared variables.

Each student in our Live Online classes receives a comprehensive set of materials, including course notes and all the class examples.
  • Batch size up to 1 to 3.
  • Access to the trainer any time for any questions and follow-ups.
  • Online in-person training.
  • Every session is followed by practical assignments.
  • Numerous assignments carefully designed on every topic by our professional trainers.
  • Guidance from experienced and professional people in software industry.
  • Assignments evaluation, feedbacks and encouragements to develop in better way.
  • Focus on hands-on training by students during sessions.

Prerequisites


Need to be familiar with basic RDBMS concepts with skills to write queries. Knowing SQL and T-SQL would be an added advantage.


Syllabus


Duration: Min 20 hours of classroom training.
Min 25 assignments.

OVER VIEW OF DATA INTEGRATION AND ETL
  • What is Data Integration?
  • What is ETL?
  • Overview of typical Data Integration and Integration tool
INTRODUCTION TO SQL SERVER INTEGRATION SERVICES
  • Overview of SQL Server Integration Services
  • Creating an Integration Services Solution
  • Components of SSIS solution
  • Control flow and Data Flow
  • Components of SSIS solution
Developing a basic SSIS solution
  • Launching BIDS
  • The Toolbox
  • Solution Explorer
  • The Properties
  • The Variables window
  • The SSIS menu
  • Runtime Engine Dataflow Engine
  • Creating SSIS Packages
  • Solution, project and package creation
DEVELOPING DATA TRANSFER TASK
  • Database as source and destination
  • Using table, SQL Command as source
  • Using files as source or destination
DEVELOPING EXECUTE SQL TASK
  • Using SP, SQL Command
EXPRESSIONS AND VARIABLES
  • The expression language in SSIS
  • The scoping of variables
TROUBLESHOOTING SSIS
  • How to diagnose a problem in SSIS
  • Sequence container
  • How to create a breakpoint in SSIS
COMMON DATA TRANSFORMATIONS
  • Derived Column
  • Data Conversion
  • Aggregate
  • Sort
  • Union All
  • Multicast
  • Merge
  • Merge Join
  • Conditional Split
DW RELATED TRANSFORMATIONS
  • Look up transformation
CONTROL FLOW TASKS
  • FTP Task
  • Script Task
  • Send Mail Task
WORKING WITH CONTAINERS
  • For Loop
  • For each Loop
ADVANCED DATA TRANSFORMATIONS
  • The Fuzzy Lookup Transformations
EVENT HANDLING AND LOGGING IN SSIS
  • Event Handlers
  • Logging Providers
MANAGING SSIS PACKAGES
  • Deploying SSIS Routines to SQL Servers
  • Manually Running SSIS Routines Automating SSIS Routine Execution
  • Using configuration files to externalize configurations
  • Configuring Automatic Notifications of SSIS Routine Execution