Enable Technology



About Enable Technology Preston SQL Server Integration Services Training Courses

We offer intensive two and three days SQL Server Integration Services courses. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. Each course participant will be issued with training SQL Server Integration Services resources which they can continue to use after the training. Our policy is to provide open ended SQL Server Integration Services post training support to participants. This additional service is an important part ofhow we help people implement the skills they have learned in the workplace.

We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the SQL Server Integration Services onsite. If delivery onsite is an issue we will organise a socially distanced venue near you in Preston. We will work with you prior to the course to tailor the SQL Server Integration Services syllabus to match your requirements.

Taught SQL Server Integration Services courses are also available online. Course participants can join a a virtual classroom. They can talk to the tutor, share their screen and watch the tutor demonstrate each topic.

The Enable Technology group of companies has been operating continuously providing IT training since 1998. Our clients include: Homeserve PLC, West Bromwich Building Society, University of Birmingham, Shell UK Oil Products Ltd, Keele University, Aston University, Boots UK Limited and Nuclear Engineering Services.

Microsoft SQL Server Integration Services SSIS

  • 2 day course
  • Location: Preston
  • 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 Container Loops Performing Joins
    Administration of SQL Using the SQL Management Objects Tasks Data Flow
    Utilizing Sequences in a Container
    Performing Joins with the Lookup Transformation
    SQL Server Integration Services Architecture
    Understanding Deployment Strategies 
    Managing with Control Flow
    Utilizing SQL Server Integration Services Data Typing
    Moving Data with Data Flow
    Examining the Transformation and Other Tasks Variables, Parameters and Expressions
    Utilizing Data Preparation Tasks
    Using Package Hierarchies: Parent Child
    Working with Advanced Logging and Reporting
    Understanding Parameters SQL Server Integration Services Tools
    Understanding Packages
    Define and Use Variables and Parameters
    Using the Workflow Tasks
    Data Loading with the Analysis Services Tasks
    Coding the Script Task
    Optimizing Sources for Extraction
    Creating Dynamic Packages

  • See Training Course Details...

Email us about this courses

Other Preston Enable Technology Training Courses

Access VBA Preston Training Courses
Power Query - Preston Excel Training Courses
Access Preston Training Courses