Enable Technology



About Enable Technology Monmouth SQL Server Integration Services Training Courses

We are a company that offers short, practical, SQL Server Integration Services hands on technology 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. It is our policy to support delegates apply their new skill after the course. All candidate will be able to contact the course Tutor for as long as they feel they need help.

SQL Server Integration Services training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. We can deliver at your premises. We can provide the equipment. If delivery onsite is an issue we will organise a socially distanced venue near you in Monmouth. We offer the option of working with you to develop a bespoke SQL Server Integration Services programme which precisely matches your organisations training requirements.

We also deliver this course online. Delegates participate in a virtual SQL Server Integration Services class and can both talk to and share their screen with the tutor.

Our teaching team have over twenty years continuous technical training experience. Our clients include: Royal Air Force, Carillion PLC, Lloyds TSB Bank PLC, Dollond & Aitchison Limited, Halfords Group PLC, Canadian High Commission, National Power PLC and Wolverhampton City Council.

Microsoft SQL Server Integration Services SSIS

  • 2 day course
  • Location: Monmouth
  • 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 ...
  • Working in the Explore Window
    Handling Errors Common SQL Server Integration Services Design Patterns
    Using Package Hierarchies: Parent Child
    Understanding Packages
    The SQL Server Integration Service
    Using the Best Practices Debugging SQL Server Integration Services Packages
    Data Loading with the Analysis Services Tasks
    Managing with Control Flow
    Utilizing the Import/Export Wizard
    Creating Dynamic Packages
    Using Destinations and Understanding choices
    Utilizing Container Loops Performing Joins
    SQL Server Integration Services Architecture
    Performing Joins with the Merge Transformation
    Understanding Variables
    Utilizing Cache Modes in Joins Tuning SQL Server Integration Services Packages
    Performing Joins with the Lookup Transformation
    Creating SQL Server Integration Services Packages
    Using the Workflow Tasks
    Using Expressions in Packages Containers
    Overview of Containers

  • See Training Course Details...

Email us about this courses

Other Monmouth Enable Technology Training Courses

Power Query Monmouth Training Courses
Excel Power Pivot - Monmouth Excel Training Courses
Power BI - Monmouth Microsoft Power BI Training Courses