Enable Technology



About Enable Technology Blackwood SQL Server Integration Services Training Courses

Enable Technology specialise in succinct skills based SQL Server Integration Services training. All Enable Technology tutors are Microsoft certified experts. Each person attending a course takes away SQL Server Integration Services courseware which can be used as reference materials after the training. We offer a post training support service and delegates will have access to a Microsoft expert on SQL Server Integration Services for as long as they need.

Our primary method of delivery is instructor led training coupled with practical hands on activities. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the SQL Server Integration Services onsite. We are also more than happy to organise a local course at a socially distanced training location in Blackwood. We are more than happy to incorporate additional topics to accommodate your organisations SQL Server Integration Services 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 group of companies has been delivering technical training principally in the Midlands region for twenty years. Our clients include: Birmingham City University, Unipart Group, National Power PLC, West Bromwich Building Society, Halfords Group PLC, Dollond & Aitchison Limited, Carillion PLC and Yell Group PLC.

Microsoft SQL Server Integration Services SSIS

  • 2 day course
  • Location: Blackwood
  • 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 ...
  • Utilizing the Import/Export Wizard
    Creating Dynamic Packages
    Data Loading with the Analysis Services Tasks
    Overview of Containers
    Understanding Variables
    Utilizing Sequences in a Container
    Utilizing Cache Modes in Joins Tuning SQL Server Integration Services Packages
    Managing SQL with the SQL Tasks
    Creating SQL Server Integration Services Packages
    Handling Errors Common SQL Server Integration Services Design Patterns
    Optimizing Sources for Extraction
    Using Package Hierarchies: Parent Child
    Choosing the Script Task or Script Component
    Define and Use Variables and Parameters
    Using Expressions in Packages Containers
    Coding the Script Task
    Working with Advanced Logging and Reporting
    Utilizing Connection Managers SQL Server Integration Services Tasks
    Looping and Sequence Tasks
    Understanding Packages
    Working with XML

  • See Training Course Details...

Email us about this courses

Other Blackwood Enable Technology Training Courses

Excel Power Pivot Blackwood Training Courses
Report Builder Blackwood Training Courses
Power Query Blackwood Training Courses