Enable Technology



About Enable Technology Rhyl SQL Server Integration Services Training Courses

We are company which specialises in short, two and three day intensive SQL Server Integration Services technology training courses. The person delivering the course will be a Microsoft Solutions Expert (MCSE). Each course participant will be issued with training SQL Server Integration Services resources which they can continue to use after the training. Anyone attending the course can contact the Tutor for as long as they like after the SQL Server Integration Services course. The ongoing support by a Microsoft expert is an important part of the service we offer.

Courses are instructor led and groups sizes small. We can bring the equipment necessary to deliver SQL Server Integration Services courses at your site. If you prefer we can offer an offsite socially distanced training location in Rhyl. The SQL Server Integration Services syllabus can be modified to accommodate your specific training needs.

We can also deliver SQL Server Integration Services courses through an online virtual classroom. You log onto a scheduled virtual classroom, can view the tutor and exercise demonstrations, ask questions and allow the tutor to share your screen if need help completing the course exercises.

The Enable Technology group of companies has been operating continuously providing IT training since 1998. Our clients include: University of Birmingham, EDF Energy PLC, Carillion PLC, Fujistu PLC, West Bromwich Building Society, Royal Air Force, Homeserve PLC and Wolverhampton City Council.

Microsoft SQL Server Integration Services SSIS

  • 2 day course
  • Location: Rhyl
  • Telephone on 01952 938014
  • Course Outline
  • This two day intensive course introduces SQL Server Integration Services. No prior knowledge of Integration Services is assumed.

  • Some of the training topics covered include ...
  • Performing Joins with the Lookup Transformation
    Managing SQL with the SQL Tasks
    Choosing the Script Task or Script Component
    Examining the SSIS Engine
    Utilizing SQL Server Integration Services Data Typing
    Coding the Script Task
    Working in the Explore Window
    Working with Advanced Logging and Reporting
    Utilizing Connection Managers SQL Server Integration Services Tasks
    The SQL Server Integration Service
    Define and Use Variables and Parameters
    Utilizing Container Loops Performing Joins
    Utilizing Data Preparation Tasks
    Creating Dynamic Packages
    Overview of Containers
    Understanding Deployment Strategies 
    Handling Errors Common SQL Server Integration Services Design Patterns
    Creating SQL Server Integration Services Packages
    Designing to Troubleshoot: Using Precedence Constraints
    Using Destinations and Understanding choices
    Optimizing Sources for Extraction

  • See Training Course Details...

Email us about this courses

Other Rhyl Enable Technology Training Courses

SSRS Rhyl Training Courses
TSQL Rhyl Training Courses
SSAS - Rhyl SQL Server Analysis Services Training Courses