Enable Technology



About Enable Technology Worcester SQL Server Integration Services Training Courses

We have a twenty year history of providing skills based SQL Server Integration Services industry training. The person delivering the course will be a Microsoft Solutions Expert (MCSE). Every person attending a SQL Server Integration Services course will be provided with training materials and practice files to retain 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.

We provide instructor led training coupled with hands on training. Enable Technology SQL Server Integration Services courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. Another option is we can organise a local socially distanced training site in Worcester. 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. Some of our clients are Canadian High Commission, Barclays Bank PLC, Boots UK Limited, Unipart Group, EDF Energy PLC, Royal & Sun Alliance Group PLC, Queen's Medical Centre Nottingham and Royal Air Force.

Microsoft SQL Server Integration Services SSIS

  • 2 day course
  • Location: Worcester
  • 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 ...
  • Examining the Transformation and Other Tasks Variables, Parameters and Expressions
    Understanding Packages
    Understanding Variables
    Performing Joins with the Lookup Transformation
    Managing with Control Flow
    Managing SQL with the SQL Tasks
    Administration of SQL Using the SQL Management Objects Tasks Data Flow
    Working in the Explore Window
    Moving Data with Data Flow
    Performing Joins with the Merge Transformation
    Utilizing Sequences in a Container
    Using Package Hierarchies: Parent Child
    The SQL Server Integration Service
    Designing to Troubleshoot: Using Precedence Constraints
    Choosing the Script Task or Script Component
    Define and Use Variables and Parameters
    Overview of Containers
    Handling Errors Common SQL Server Integration Services Design Patterns
    Using Expressions in Packages Containers
    Creating Dynamic Packages
    Utilizing Container Loops Performing Joins

  • See Training Course Details...

Email us about this courses

Other Worcester Enable Technology Training Courses

Excel 365 Advanced Worcester Training Courses
TSQL Worcester Training Courses
Excel 365 Intermediate Worcester Training Courses