Enable Technology



About Enable Technology Wythenshawe SQL Server Integration Services Training Courses

Enable Technology provides practical SQL Server Integration Services skills based technology training. The course will always be taught by a Microsoft Certified Professional (MCP). We provide every candidate with SQL Server Integration Services training materials which they keep after the course. If delegates have have questions about SQL Server Integration Services after the course they are welcome to contact the course Tutor. This post training support is ongoing.

Courses are instructor led and groups sizes small. Our SQL Server Integration Services training courses can be delivered onsite at your location. You simply need to provide a room. We can supply the equipment and software. 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 adjusted and additional topics incorporated if helpful.

This instructor led course is also available online. Participants can log onto a virtual classroom and will be able to see the tutors screen, ask questions real time and share their screen with the Tutor.

Our teaching team have been delivering technical training in the Midlands for twenty years. Some of our clients are Loughborough University, Cadbury PLC, Dollond & Aitchison Limited, Wolverhampton City Council, Yell Group PLC, GKN PLC, Norwich Union PLC and Nationwide Building Society Limited.

Microsoft SQL Server Integration Services SSIS

  • 2 day course
  • Location: Wythenshawe
  • 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 
    Coding the Script Task
    Optimizing Sources for Extraction
    Looping and Sequence Tasks
    Understanding Variables
    Utilizing SQL Server Integration Services Data Typing
    Utilizing Container Loops Performing Joins
    Moving Data with Data Flow
    Using the Workflow Tasks
    Administration of SQL Using the SQL Management Objects Tasks Data Flow
    Overview of Containers
    The SQL Server Integration Service
    Using Package Hierarchies: Parent Child
    Understanding Parameters SQL Server Integration Services Tools
    Utilizing the Import/Export Wizard
    Handling Errors Common SQL Server Integration Services Design Patterns
    Understanding Packages
    Creating SQL Server Integration Services Packages
    Define and Use Variables and Parameters
    Utilizing Cache Modes in Joins Tuning SQL Server Integration Services Packages
    Choosing the Script Task or Script Component

  • See Training Course Details...

Email us about this courses

Other Wythenshawe Enable Technology Training Courses

SQL - Wythenshawe SQL Training Courses
SSRS - Wythenshawe SQL Server Reporting Services Training Courses
Excel 365 Basic Wythenshawe Training Courses