Enable Technology



About Enable Technology Warwick SQL Server Integration Services Training Courses

We are a company that provides short intensive SQL Server Integration Services training courses. The training will be delivered by a Microsoft professional with development experience. All course participants are issued SQL Server Integration Services training manuals they can refer to after the course. 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.

SQL Server Integration Services training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. Enable Technology can provide SQL Server Integration Services courses onsite at your location. We will bring the necessary laptops with the required software installed. We can also deliver the SQL Server Integration Services course at a socially distanced local training venue in Warwick. The SQL Server Integration Services syllabus can be modified to accommodate your specific training needs.

We also deliver this course online. Delegates participate in a virtual SQL Server Integration Services class and can both talk to and share their screen with the tutor.

Our teaching team have over twenty years continuous technical training experience. Some of our clients are Royal Air Force, Loughborough University, Dollond & Aitchison Limited, Wolverhampton City Council, TalkTalk Direct Limited, Lloyds TSB Bank PLC, Queen's Medical Centre Nottingham and West Bromwich Building Society.

Microsoft SQL Server Integration Services SSIS

  • 2 day course
  • Location: Warwick
  • 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 ...
  • Optimizing Sources for Extraction
    Administration of SQL Using the SQL Management Objects Tasks Data Flow
    Understanding Packages
    Creating SQL Server Integration Services Packages
    Using the Workflow Tasks
    Working in the Explore Window
    The SQL Server Integration Service
    Designing to Troubleshoot: Using Precedence Constraints
    Understanding Variables
    Utilizing Container Loops Performing Joins
    Using the Best Practices Debugging SQL Server Integration Services Packages
    Using Package Hierarchies: Parent Child
    Looping and Sequence Tasks
    Utilizing Cache Modes in Joins Tuning SQL Server Integration Services Packages
    Handling Errors Common SQL Server Integration Services Design Patterns
    Examining the Transformation and Other Tasks Variables, Parameters and Expressions
    Performing Joins with the Merge Transformation
    Define and Use Variables and Parameters
    Utilizing Sequences in a Container
    Utilizing Data Preparation Tasks
    Creating Dynamic Packages

  • See Training Course Details...

Email us about this courses

Other Warwick Enable Technology Training Courses

JavaScript Warwick Training Courses
PL/SQL - Warwick SQL Training Courses
VBA Warwick Training Courses