Enable Technology

SQL SERVER INTEGRATION SERVICES DORCHESTER TRAINING COURSES 

SQL SERVER INTEGRATION SERVICES TRAINING COURSES DORCHESTER




About Enable Technology Dorchester SQL Server Integration Services Training Courses

Enable Technology specialise in succinct skills based SQL Server Integration Services training. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. We provide every candidate with SQL Server Integration Services training materials which they keep after the course. If delegates have have questions about SQL Server Integration Services after the course they are welcome to contact the course Tutor. This post training support is ongoing.

Courses are instructor led and groups sizes small. Enable Technology SQL Server Integration Services courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. If you prefer we can offer an offsite training location in Dorchester. We are happy to discuss customising the course content should you have particular SQL Server Integration Services training requirements.

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.

The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Our clients include: Homeserve PLC, National Power PLC, Carillion PLC, GKN PLC, Fujistu PLC, Birmingham City University, TalkTalk Direct Limited and Nationwide Building Society 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 ...
  • Using the Workflow Tasks
    Coding the Script Task
    Working with Advanced Logging and Reporting
    Examining the SSIS Engine
    Understanding Variables
    Understanding Parameters SQL Server Integration Services Tools
    Moving Data with Data Flow
    Handling Errors Common SQL Server Integration Services Design Patterns
    Data Loading with the Analysis Services Tasks
    Creating SQL Server Integration Services Packages
    SQL Server Integration Services Architecture
    Utilizing Container Loops Performing Joins
    Performing Joins with the Merge Transformation
    Choosing the Script Task or Script Component
    Understanding Packages
    Managing SQL with the SQL Tasks
    Using Destinations and Understanding choices
    Utilizing Sequences in a Container
    Working in the Explore Window
    Designing to Troubleshoot: Using Precedence Constraints
    Utilizing Cache Modes in Joins Tuning SQL Server Integration Services Packages

  • See Training Course Details...



Email us about this courses



Other Dorchester Enable Technology Training Courses

SSAS - Dorchester SQL Server Analysis Services Training Courses
Oracle SQL Dorchester Training Courses
Power BI - Dorchester Microsoft Power BI Training Courses