Enable Technology



About Enable Technology Burton On Trent SQL Server Integration Services Training Courses

Enable Technology SQL Server Integration Services courses are short, skill focused and hands on. The training will be delivered by a Microsoft professional with development experience. Every course participant is given SQL Server Integration Services courseware which they can refer to after the training. 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.

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. We can bring the equipment necessary to deliver SQL Server Integration Services courses at your site. 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.

The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Our clients include: Cadbury PLC, Dollond & Aitchison Limited, Fujistu PLC, Carillion PLC, GKN PLC, Vodafone Group Services, Lloyds TSB Bank PLC and National Power PLC.

Microsoft SQL Server Integration Services SSIS

  • 2 day course
  • Location: Burton On Trent
  • 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 ...
  • Working with XML
    Choosing the Script Task or Script Component
    Creating Dynamic Packages
    Overview of Containers
    Moving Data with Data Flow
    Data Loading with the Analysis Services Tasks
    Examining the SSIS Engine
    Handling Errors Common SQL Server Integration Services Design Patterns
    Understanding Packages
    Managing SQL with the SQL Tasks
    Utilizing Connection Managers SQL Server Integration Services Tasks
    Utilizing Cache Modes in Joins Tuning SQL Server Integration Services Packages
    Understanding Parameters SQL Server Integration Services Tools
    Utilizing SQL Server Integration Services Data Typing
    Using the Best Practices Debugging SQL Server Integration Services Packages
    Examining the Transformation and Other Tasks Variables, Parameters and Expressions
    Utilizing Sequences in a Container
    Utilizing Data Preparation Tasks
    Performing Joins with the Merge Transformation
    Looping and Sequence Tasks
    Understanding Deployment Strategies 

  • See Training Course Details...

Email us about this courses

Other Burton On Trent Enable Technology Training Courses

Excel 365 Advanced - Burton On Trent Excel Training Courses
SSRS Burton On Trent Training Courses
Access - Burton On Trent Access Training Courses