Enable Technology



About Enable Technology Barnsley SQL Server Integration Services Training Courses

Enable Technology offer short intensive skills based SQL Server Integration Services training courses. We guarantee the training will be delivered by a Microsoft certified expert. Every course participant is given SQL Server Integration Services courseware which they can refer to after the training. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with SQL Server Integration Services queries.

Our primary method of delivery is instructor led training coupled with practical hands on activities. Enable Technology can supply all of the equipment necessary to deliver SQL Server Integration Services courses onsite at your offices. You simply need to provide a suitable room. Another way we could deliver the SQL Server Integration Services course is at a local socially distanced training site. We will work with you prior to the course to tailor the SQL Server Integration Services syllabus to match your requirements.

SQL Server Integration Services courses are available via virtual classrooms. Training participants can log onto scheduled classes, watch the tutor talk through and demonstrate each topic, ask questions and share their screen with the tutor if they need assistance.

We have two decades of delivering technical training predominantly in the West Midlands. Some of our clients are West Bromwich Building Society, Homeserve PLC, Canadian High Commission, Shell UK Oil Products Ltd, Royal & Sun Alliance Group PLC, Norwich Union PLC, Aston University and Keele University.

Microsoft SQL Server Integration Services SSIS

  • 2 day course
  • Location: Barnsley
  • 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 Cache Modes in Joins Tuning SQL Server Integration Services Packages
    Using Package Hierarchies: Parent Child
    Using Expressions in Packages Containers
    Performing Joins with the Merge Transformation
    Data Loading with the Analysis Services Tasks
    Understanding Parameters SQL Server Integration Services Tools
    The SQL Server Integration Service
    Using Destinations and Understanding choices
    Define and Use Variables and Parameters
    Overview of Containers
    Utilizing Data Preparation Tasks
    Utilizing Sequences in a Container
    Understanding Variables
    SQL Server Integration Services Architecture
    Working in the Explore Window
    Looping and Sequence Tasks
    Performing Joins with the Lookup Transformation
    Administration of SQL Using the SQL Management Objects Tasks Data Flow
    Utilizing Connection Managers SQL Server Integration Services Tasks
    Coding the Script Task
    Utilizing Container Loops Performing Joins

  • See Training Course Details...

Email us about this courses

Other Barnsley Enable Technology Training Courses

Data Warehouse - Barnsley SQL Training Courses
Excel Power Pivot - Barnsley Excel Training Courses
SSAS - Barnsley SQL Server Analysis Services Training Courses