Enable Technology



About Enable Technology Warrington SQL Server Integration Services Training Courses

Enable Technology has twenty year track record of providing short intensive SQL Server Integration Services skills based training courses. The training will be delivered by a Microsoft professional with development experience. 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. Our SQL Server Integration Services training courses can be delivered onsite at your location. You simply need to provide a room. We can supply the equipment and software. We are also more than happy to organise a local course at a socially distanced training location in Warrington. The SQL Server Integration Services syllabus can be adjusted and additional topics incorporated if helpful.

SQL Server Integration Services courses are also available online. Participants can join scheduled virtual classes, watch the tutor demonstrate the topic, ask questions and share their screen

The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Some of our clients are Barclays Bank PLC, GKN PLC, Royal & Sun Alliance Group PLC, Halfords Group PLC, Nationwide Building Society Limited, South Staffordshire Water PLC, Canadian High Commission and Fujistu PLC.

Microsoft SQL Server Integration Services SSIS

  • 2 day course
  • Location: Warrington
  • 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 ...
  • Examining the SSIS Engine
    Working with XML
    Handling Errors Common SQL Server Integration Services Design Patterns
    Using the Workflow Tasks
    Working in the Explore Window
    Utilizing Container Loops Performing Joins
    Examining the Transformation and Other Tasks Variables, Parameters and Expressions
    SQL Server Integration Services Architecture
    Optimizing Sources for Extraction
    Working with Advanced Logging and Reporting
    Creating SQL Server Integration Services Packages
    Utilizing Cache Modes in Joins Tuning SQL Server Integration Services Packages
    Using Package Hierarchies: Parent Child
    Utilizing the Import/Export Wizard
    Designing to Troubleshoot: Using Precedence Constraints
    Performing Joins with the Merge Transformation
    The SQL Server Integration Service
    Understanding Deployment Strategies 
    Data Loading with the Analysis Services Tasks
    Define and Use Variables and Parameters
    Looping and Sequence Tasks

  • See Training Course Details...

Email us about this courses

Other Warrington Enable Technology Training Courses

JQuery - Warrington JavaScript Training Courses
SSAS Tabular - Warrington SQL Server Analysis Services Training Courses
Excel 365 Advanced - Warrington Excel Training Courses