IE Warning
Your browser is out of date!

This website uses the latest web technologies so it requires an up-to-date, fast browser!
Try Firefox or Chrome!
Back to top
Twitter Logo
LinkedIn Logo Google+ Logo
Telephone: 023 9270 4041

Microsoft SQL Sever LogoMicrosoft SQL Server Integration Services (SSIS) Course

Course Objectives

Microsoft Integration Services is a platform for building enterprise-level data integration and data transformations solutions. You use Integration Services to solve complex business problems by copying or downloading files, sending e-mail messages in response to events, updating data warehouses, cleaning and mining data, and managing SQL Server objects and data.

The packages can work alone or in concert with other packages to address complex business needs. Integration Services can extract and transform data from a wide variety of sources such as XML data files, flat files, and relational data sources, and then load the data into one or more destinations.

Course Modules

The following modules will be will be covered on the course.

  1. Introduction to SSIS
  2. SSIS Tools
  3. SSIS Tasks
  4. The Data Flow
  5. Using Variables, Parameters and Expressions
  6. SSIS Containers
  7. Joining Data
  8. Creating a Data Cleansing Package
  9. Scripting in SSIS
  10. Advanced Data Cleansing
  11. Reliability & Scalability
  12. Programming and Extending SSIS
  13. Event and Error Handling
  14. Administrating SSIS

Target Audience

This course is intended for end users or administrators of Microsoft SQL Server.

Course Reviews

The best course that I have ever been on! The trainer explained everything in detail and lots of practical examples to back it all up.  A really enjoyable course in relaxed surroundings.
Anthony Carter - Chichester Marketing Talk