Enable Technology



About Enable Technology Durham SQL Server Integration Services Training Courses

Enable Technology provides practical SQL Server Integration Services skills based technology training. 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. Anyone attending the course can contact the Tutor for as long as they like after the SQL Server Integration Services course. The ongoing support by a Microsoft expert is an important part of the service we offer.

SQL Server Integration Services courses are taught by a Microsoft Certified Solutions Expert. Enable Technology can provide SQL Server Integration Services courses onsite at your location. We will bring the necessary laptops with the required software installed. If you prefer we can offer an offsite socially distanced training location in Durham. We will work with you prior to the course to tailor the SQL Server Integration Services syllabus to match your requirements.

We can also deliver SQL Server Integration Services courses through an online virtual classroom. You log onto a scheduled virtual classroom, can view the tutor and exercise demonstrations, ask questions and allow the tutor to share your screen if need help completing the course exercises.

The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Our clients include: Fujistu PLC, Boots UK Limited, National Power PLC, Royal Air Force, Aston University, West Bromwich Building Society, Lloyds TSB Bank PLC and Birmingham City University.

Microsoft SQL Server Integration Services SSIS

  • 2 day course
  • Location: Durham
  • 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 ...
  • Looping and Sequence Tasks
    Using Destinations and Understanding choices
    Utilizing Container Loops Performing Joins
    Define and Use Variables and Parameters
    Examining the Transformation and Other Tasks Variables, Parameters and Expressions
    Working with Advanced Logging and Reporting
    Data Loading with the Analysis Services Tasks
    Utilizing Connection Managers SQL Server Integration Services Tasks
    Using the Best Practices Debugging SQL Server Integration Services Packages
    Using Package Hierarchies: Parent Child
    Utilizing the Import/Export Wizard
    Understanding Variables
    Understanding Deployment Strategies 
    Moving Data with Data Flow
    Utilizing Data Preparation Tasks
    Choosing the Script Task or Script Component
    Overview of Containers
    Optimizing Sources for Extraction
    Utilizing SQL Server Integration Services Data Typing
    Understanding Packages
    Handling Errors Common SQL Server Integration Services Design Patterns

  • See Training Course Details...

Email us about this courses

Other Durham Enable Technology Training Courses

Oracle SQL - Durham SQL Training Courses
SQL - Durham SQL Training Courses
SSAS Tabular - Durham SQL Server Analysis Services Training Courses