Enable Technology



About Enable Technology Colwyn Bay SQL Server Integration Services Training Courses

Enable Technology provides practical SQL Server Integration Services skills based technology training. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. Every course participant is given SQL Server Integration Services courseware which they can refer to after the training. We offer a post training support service and delegates will have access to a Microsoft expert on SQL Server Integration Services for as long as they need.

Delegates are taught by an experienced Microsoft professional. SQL Server Integration Services courses are delivered through a mix of practical hands on exercises and walk throughs. Enable Technology can provide SQL Server Integration Services courses onsite at your location. We will bring the necessary laptops with the required software installed. Alternatively we could schedule a course at a local socially distanced venue in Colwyn Bay. We offer the option of working with you to develop a bespoke SQL Server Integration Services programme which precisely matches your organisations training requirements.

SQL Server Integration Services courses are also available online. Participants can join scheduled virtual classes, watch the tutor demonstrate the topic, ask questions and share their screen

We have operated primarily in the West Midlands for twenty years. Our clients include: Royal & Sun Alliance Group PLC, Norfolk Police Constabulary, West Bromwich Building Society, Dollond & Aitchison Limited, Keele University, National Power PLC, Birmingham City Council and Carillion PLC.

Microsoft SQL Server Integration Services SSIS

  • 2 day course
  • Location: Colwyn Bay
  • 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 ...
  • Using Package Hierarchies: Parent Child
    Overview of Containers
    Utilizing SQL Server Integration Services Data Typing
    Understanding Variables
    The SQL Server Integration Service
    Creating Dynamic Packages
    Performing Joins with the Merge Transformation
    Utilizing Connection Managers SQL Server Integration Services Tasks
    Choosing the Script Task or Script Component
    Using Expressions in Packages Containers
    Understanding Deployment Strategies 
    Examining the Transformation and Other Tasks Variables, Parameters and Expressions
    Optimizing Sources for Extraction
    Moving Data with Data Flow
    Working in the Explore Window
    Utilizing the Import/Export Wizard
    Using the Workflow Tasks
    Data Loading with the Analysis Services Tasks
    Utilizing Cache Modes in Joins Tuning SQL Server Integration Services Packages
    Performing Joins with the Lookup Transformation
    Creating SQL Server Integration Services Packages

  • See Training Course Details...

Email us about this courses

Other Colwyn Bay Enable Technology Training Courses

JQuery Mobile - Colwyn Bay JavaScript Training Courses
Oracle SQL - Colwyn Bay SQL Training Courses
VBA Colwyn Bay Training Courses