Enable Technology



About Enable Technology Skelmersdale SQL Server Integration Services Training Courses

We offer intensive two and three days SQL Server Integration Services courses. The tutor delivering the course will be a Microsoft certified expert. Everyone attending a SQL Server Integration Services course receives learning resources which also serves as a reference source after the course. Course participants are welcome contact the Tutor after the course with specific SQL Server Integration Services queries. This support is open ended.

We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. We can set up a training lab at your premises and deliver SQL Server Integration Services courses onsite at your site. Another way we could deliver the SQL Server Integration Services course is at a local socially distanced training site. The SQL Server Integration Services syllabus can be modified to accommodate your specific training needs.

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.

In the Midlands the Enable Technology team have been providing technical training since 1998. Our clients include: Norfolk Police Constabulary, Keele University, Barclays Bank PLC, Yell Group PLC, GKN PLC, Cadbury PLC, Nationwide Building Society Limited and Birmingham City Council.

Microsoft SQL Server Integration Services SSIS

  • 2 day course
  • Location: Skelmersdale
  • 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 Data Preparation Tasks
    Using Package Hierarchies: Parent Child
    Utilizing Connection Managers SQL Server Integration Services Tasks
    Creating SQL Server Integration Services Packages
    Utilizing SQL Server Integration Services Data Typing
    Creating Dynamic Packages
    Choosing the Script Task or Script Component
    Handling Errors Common SQL Server Integration Services Design Patterns
    Performing Joins with the Lookup Transformation
    Working with Advanced Logging and Reporting
    Utilizing the Import/Export Wizard
    Moving Data with Data Flow
    Using Destinations and Understanding choices
    Utilizing Cache Modes in Joins Tuning SQL Server Integration Services Packages
    Performing Joins with the Merge Transformation
    Utilizing Sequences in a Container
    Understanding Parameters SQL Server Integration Services Tools
    Understanding Packages
    Define and Use Variables and Parameters
    Coding the Script Task
    Data Loading with the Analysis Services Tasks

  • See Training Course Details...

Email us about this courses

Other Skelmersdale Enable Technology Training Courses

Excel 365 Intermediate Skelmersdale Training Courses
PL/SQL Skelmersdale Training Courses
SSAS - Skelmersdale SQL Server Analysis Services Training Courses