Enable Technology



About Enable Technology Dorchester SQL Server Integration Services Training Courses

Enable Technology SQL Server Integration Services courses are short, skill focused and hands on. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. Each person attending a course takes away SQL Server Integration Services courseware which can be used as reference materials 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.

Courses are instructor led and groups sizes small. We can deliver at your premises. We can provide the equipment. Another way we could deliver the SQL Server Integration Services course is at a local socially distanced training site. We will work with you prior to the course to tailor the SQL Server Integration Services syllabus to match your requirements.

We also deliver this course online through virtual classrooms. Delegates can join scheduled SQL Server Integration Services classes, view the tutors demonstrations, ask questions and share their screen with the trainer if they need assistance.

The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Some of our clients are Royal Air Force, Aston University, Carillion PLC, Birmingham City University, Canadian High Commission, Keele University, Birmingham City Council and TalkTalk Direct Limited.

Microsoft SQL Server Integration Services SSIS

  • 2 day course
  • Location: Dorchester
  • 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
    Working with XML
    Managing with Control Flow
    Utilizing the Import/Export Wizard
    Handling Errors Common SQL Server Integration Services Design Patterns
    Optimizing Sources for Extraction
    Utilizing Connection Managers SQL Server Integration Services Tasks
    Using Package Hierarchies: Parent Child
    Utilizing Container Loops Performing Joins
    Creating Dynamic Packages
    Working with Advanced Logging and Reporting
    SQL Server Integration Services Architecture
    Understanding Deployment Strategies 
    Understanding Parameters SQL Server Integration Services Tools
    Utilizing Sequences in a Container
    Performing Joins with the Merge Transformation
    Utilizing Cache Modes in Joins Tuning SQL Server Integration Services Packages
    The SQL Server Integration Service
    Utilizing Data Preparation Tasks
    Coding the Script Task
    Moving Data with Data Flow

  • See Training Course Details...

Email us about this courses

Other Dorchester Enable Technology Training Courses

Excel 365 Intermediate Dorchester Training Courses
Access VBA - Dorchester Access Training Courses
Report Builder - Dorchester SQL Server Reporting Services Training Courses