Enable Technology



About Enable Technology Wigan SQL Server Integration Services Training Courses

Enable Technology SQL Server Integration Services courses are short, skill focused and hands on. The training will be delivered by a Microsoft professional with development experience. All course participants are issued SQL Server Integration Services training manuals they can refer to after the course. Enable Technology offer post course help to all delegates. Participants on the SQL Server Integration Services course can contact the tutor for as long as they like if they encounter SQL Server Integration Services problems.

We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. Enable Technology can supply all of the equipment necessary to deliver SQL Server Integration Services courses onsite at your offices. You simply need to provide a suitable room. Another option is we can organise a local socially distanced training site in Wigan. The SQL Server Integration Services syllabus can be modified to accommodate your specific training needs.

This instructor led course is also available online. Participants can log onto a virtual classroom and will be able to see the tutors screen, ask questions real time and share their screen with the Tutor.

We have operated primarily in the West Midlands for twenty years. Our clients include: Keele University, South Staffordshire Water PLC, Cadbury PLC, Barclays Bank PLC, Royal Air Force, TalkTalk Direct Limited, Yell Group PLC and DHL Express.

Microsoft SQL Server Integration Services SSIS

  • 2 day course
  • Location: Wigan
  • 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 ...
  • Managing with Control Flow
    Using Package Hierarchies: Parent Child
    Performing Joins with the Lookup Transformation
    Optimizing Sources for Extraction
    Overview of Containers
    Utilizing Sequences in a Container
    The SQL Server Integration Service
    Using Expressions in Packages Containers
    Using the Best Practices Debugging SQL Server Integration Services Packages
    Managing SQL with the SQL Tasks
    Creating Dynamic Packages
    Understanding Variables
    Handling Errors Common SQL Server Integration Services Design Patterns
    Define and Use Variables and Parameters
    Utilizing Container Loops Performing Joins
    Choosing the Script Task or Script Component
    Performing Joins with the Merge Transformation
    Using Destinations and Understanding choices
    Utilizing Cache Modes in Joins Tuning SQL Server Integration Services Packages
    Examining the SSIS Engine
    Understanding Deployment Strategies 

  • See Training Course Details...

Email us about this courses

Other Wigan Enable Technology Training Courses

Power Query - Wigan Excel Training Courses
Access - Wigan Access Training Courses
SSAS Wigan Training Courses