Enable Technology



About Enable Technology Stafford SQL Server Integration Services Training Courses

We are company which specialises in short, two and three day intensive SQL Server Integration Services technology training courses. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. All candidates receive comprehensive SQL Server Integration Services training materials and practice files which are theirs to refer to after the course. 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.

SQL Server Integration Services courses are taught by a Microsoft Certified Solutions Expert. We are set up to deliver SQL Server Integration Services training courses onsite at your premises. Another way we could deliver the SQL Server Integration Services course is at a local socially distanced training site. We are happy to modify the SQL Server Integration Services syllabus to match your teams training requirements.

This course can also be delivered in a virtual classroom. Delegates can log into a scheduled SQL Server Integration Services course, watch the tutor demonstrate tasks, ask questions and share their own screen.

The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Some of our clients are Keele University, Lloyds TSB Bank PLC, Norfolk Police Constabulary, Homeserve PLC, Wolverhampton City Council, Loughborough University, Royal Air Force and Shell UK Oil Products Ltd.

Microsoft SQL Server Integration Services SSIS

  • 2 day course
  • Location: Stafford
  • 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 ...
  • Moving Data with Data Flow
    SQL Server Integration Services Architecture
    Overview of Containers
    Utilizing Container Loops Performing Joins
    Performing Joins with the Lookup Transformation
    Using Package Hierarchies: Parent Child
    Creating Dynamic Packages
    Utilizing Cache Modes in Joins Tuning SQL Server Integration Services Packages
    Utilizing Data Preparation Tasks
    Creating SQL Server Integration Services Packages
    Examining the SSIS Engine
    Performing Joins with the Merge Transformation
    Choosing the Script Task or Script Component
    Working with XML
    The SQL Server Integration Service
    Data Loading with the Analysis Services Tasks
    Using Expressions in Packages Containers
    Designing to Troubleshoot: Using Precedence Constraints
    Working in the Explore Window
    Using Destinations and Understanding choices
    Working with Advanced Logging and Reporting

  • See Training Course Details...

Email us about this courses

Other Stafford Enable Technology Training Courses

DAX - Stafford Excel Training Courses
SSRS Stafford Training Courses
Oracle SQL - Stafford SQL Training Courses