Enable Technology



About Enable Technology Smethwick SQL Server Integration Services Training Courses

We have a twenty year history of providing skills based SQL Server Integration Services industry training. 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 also provide an ongoing support service to people attending our SQL Server Integration Services courses. Delegates can contact the course tutor with specific SQL Server Integration Services questions for as long as they need following the course.

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 can also deliver the SQL Server Integration Services course at a socially distanced local training venue in Smethwick. Every SQL Server Integration Services course can be modified to meet your bespoke 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: Birmingham City Council, Aston University, Birmingham Heartlands Hospital, Vodafone Group Services, Cadbury PLC, Total Telecommunications Limited, DHL Express and Barclays Bank PLC.

Microsoft SQL Server Integration Services SSIS

  • 2 day course
  • Location: Smethwick
  • 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 Connection Managers SQL Server Integration Services Tasks
    Utilizing SQL Server Integration Services Data Typing
    Choosing the Script Task or Script Component
    Looping and Sequence Tasks
    Working with XML
    Understanding Deployment Strategies 
    Performing Joins with the Merge Transformation
    Examining the Transformation and Other Tasks Variables, Parameters and Expressions
    Using Package Hierarchies: Parent Child
    Optimizing Sources for Extraction
    Managing SQL with the SQL Tasks
    Coding the Script Task
    Understanding Packages
    Using the Workflow Tasks
    Data Loading with the Analysis Services Tasks
    Using Destinations and Understanding choices
    Utilizing Cache Modes in Joins Tuning SQL Server Integration Services Packages
    Using Expressions in Packages Containers
    Working with Advanced Logging and Reporting
    Performing Joins with the Lookup Transformation
    Moving Data with Data Flow

  • See Training Course Details...

Email us about this courses

Other Smethwick Enable Technology Training Courses

JQuery - Smethwick JavaScript Training Courses
TSQL - Smethwick SQL Training Courses
Power BI - Smethwick Microsoft Power BI Training Courses