Enable Technology



About Enable Technology Leicester SQL Server Integration Services Training Courses

Enable Technology specialise in succinct skills based SQL Server Integration Services training. We guarantee the training will be delivered by a Microsoft certified expert. Every person attending a SQL Server Integration Services course will be provided with training materials and practice files to retain after the course. Our policy is to provide open ended SQL Server Integration Services post training support to participants. This additional service is an important part ofhow we help people implement the skills they have learned in the workplace.

Courses are instructor led and groups sizes small. Enable Technology SQL Server Integration Services training courses can be delivered at your offices. We can supply the necessary software and computers. We can also deliver the SQL Server Integration Services course at a socially distanced local training venue in Leicester. The SQL Server Integration Services syllabus can be modified to accommodate your specific training needs.

SQL Server Integration Services courses are also available online. Delegates join a virtual classroom and participate in a real time instructor led course. Delegates can see the tutors screen, ask questions real time and share their screen with the tutor.

The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Some of our clients are West Bromwich Building Society, Aston University, Lloyds TSB Bank PLC, Total Telecommunications Limited, Boots UK Limited, TalkTalk Direct Limited, GKN PLC and Shell UK Oil Products Ltd.

Microsoft SQL Server Integration Services SSIS

  • 2 day course
  • Location: Leicester
  • 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 ...
  • Handling Errors Common SQL Server Integration Services Design Patterns
    Data Loading with the Analysis Services Tasks
    The SQL Server Integration Service
    Utilizing the Import/Export Wizard
    Using the Best Practices Debugging SQL Server Integration Services Packages
    Administration of SQL Using the SQL Management Objects Tasks Data Flow
    Utilizing Data Preparation Tasks
    Using the Workflow Tasks
    Utilizing SQL Server Integration Services Data Typing
    Creating SQL Server Integration Services Packages
    SQL Server Integration Services Architecture
    Examining the Transformation and Other Tasks Variables, Parameters and Expressions
    Moving Data with Data Flow
    Coding the Script Task
    Performing Joins with the Merge Transformation
    Managing SQL with the SQL Tasks
    Optimizing Sources for Extraction
    Choosing the Script Task or Script Component
    Utilizing Cache Modes in Joins Tuning SQL Server Integration Services Packages
    Define and Use Variables and Parameters
    Looping and Sequence Tasks

  • See Training Course Details...

Email us about this courses

Other Leicester Enable Technology Training Courses

Excel 365 Intermediate - Leicester Excel Training Courses
Power Query Leicester Training Courses
PL/SQL - Leicester SQL Training Courses