Enable Technology



About Enable Technology Lancaster SQL Server Integration Services Training Courses

We offer intensive two and three days SQL Server Integration Services courses. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. All course participants are issued SQL Server Integration Services training manuals they can refer to after the course. 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. Enable Technology can provide SQL Server Integration Services courses onsite at your location. We will bring the necessary laptops with the required software installed. Alternatively we could schedule a course at a local socially distanced venue in Lancaster. 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

Our teaching team have been delivering technical training in the Midlands for twenty years. Some of our clients are Yell Group PLC, Aston University, Shell UK Oil Products Ltd, Royal Air Force, Norfolk Police Constabulary, Birmingham City Council, Total Telecommunications Limited and Birmingham City University.

Microsoft SQL Server Integration Services SSIS

  • 2 day course
  • Location: Lancaster
  • 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 ...
  • Understanding Deployment Strategies 
    Using Destinations and Understanding choices
    Define and Use Variables and Parameters
    Moving Data with Data Flow
    Working in the Explore Window
    Utilizing SQL Server Integration Services Data Typing
    Using the Workflow Tasks
    Creating SQL Server Integration Services Packages
    Working with Advanced Logging and Reporting
    Looping and Sequence Tasks
    Using the Best Practices Debugging SQL Server Integration Services Packages
    Choosing the Script Task or Script Component
    Utilizing Container Loops Performing Joins
    Examining the SSIS Engine
    Using Package Hierarchies: Parent Child
    Handling Errors Common SQL Server Integration Services Design Patterns
    Examining the Transformation and Other Tasks Variables, Parameters and Expressions
    Coding the Script Task
    Understanding Packages
    Managing with Control Flow
    Using Expressions in Packages Containers

  • See Training Course Details...

Email us about this courses

Other Lancaster Enable Technology Training Courses

Excel 365 Basic - Lancaster Excel Training Courses
Excel 365 Intermediate - Lancaster Excel Training Courses
Access VBA - Lancaster Access Training Courses