Short course on Microsoft SQL Server Integration Services (SSIS) Course level: Intermediate
Total Duration: 20 Hours
Certification: Certificate of Completion will be provided after completing the course

Our SQL Server Integration Services (SSIS) is an instructor-led classroom based training course that teaches attendees how to perform data integration and transformation by using SSIS. At the end of this course attendees will have a good understanding of SSIS concepts and creating SSIS packages.

Skills Required

This course is suitable for those who already have basic knowledge on Microsoft SQL Server database and table design, SQL, T-SQL and Stored Procedure. Our Database Design with Microsoft SQL Server Training Courses cover all of the prerequisites.

Course Dates, Prices & Enrolment

12 Feb 2017 - 26 Feb 2017
3 Sundays
18 Mar 2017 - 08 Apr 2017
4 Saturdays
£400Enrol Now
30 Apr 2017 - 21 May 2017
4 Saturdays
£400Enrol Now
  1. SSIS basics
    • Solutions and projects
    • Basic packages
    • Two ways to run packages
  2. Data flow tasks
    • Connection managers
    • Sources and destinations
    • Excel, OLEDB and flat files
  3. Data transformations
    • Sorting and aggregating
    • Fully and partially blocking
    • Sampling data
  4. Data viewers
    • Attaching data viewers
    • Using dead-end destinations
  5. Variables
    • The Row Count transform
    • System variables
    • Changing scope
  6. Expressions
    • Expression syntax
    • Data types and casting
    • Conditional split transforms
    • Derived column transforms
  7. Lookup transforms
    • Full and partial caching
    • Redirecting unmatched rows
    • Cache Connection Managers
  8. Containers
    • Four types of container
    • Basic FOR loops
    • Foreach loops
    • Looping over files
    • Looping over records
    • Other foreach loops
  9. Scripting
    • Script tasks
    • Script components
    • The variable dispenser
  10. Controlling flow
    • Precedence constraints
    • Event-handling
    • Managing errors
    • Redirecting and ignoring errors
  11. Dealing with truncations
    • Overview of logging (*)
    • Logging to text files
    • Logging to SQL Server
  12. Deployment
    • Project-level deployment
    • Creating an SSIS Catalog
  13. Parameters and environments
    • Package and project parameters
    • Creating and using environments

Course Tutor

The course is working as an independent SQL BI consultant in the UK. He is a specialist consultant for building CI (Continuous Integration) solution for BI projects (SSIS, SSRS). He has considerable years of experience with the UK Financial Services Industry (Mainly in Insurance and Investment Banking). He has been presenting sessions in SQLBits, SQLPass and London SQL Server user Group since 2015.

Save Money with Packages

SAVE upto 25% by booking this course with other related courses as shown below:

Microsoft SQL Server Immersive

£765 (save £135)

This package combines
Find out more & book now

Newsletter Sign-up

Have a Question?