Enable Technology



About Enable Technology Derby SQL Server Integration Services Training Courses

Enable Technology SQL Server Integration Services courses are short, skill focused and hands on. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. Every person attending a SQL Server Integration Services course will be provided with training materials and practice files to retain after the course. Enable Technology offer post course help to all delegates. Participants on the SQL Server Integration Services course can contact the tutor for as long as they like if they encounter SQL Server Integration Services problems.

Courses are instructor led and groups sizes small. Enable Technology SQL Server Integration Services courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. We can also deliver the SQL Server Integration Services course at a socially distanced local training venue in Derby. We offer the option of working with you to develop a bespoke SQL Server Integration Services programme which precisely matches your organisations training requirements.

This instructor led course is also available online. Participants can log onto a virtual classroom and will be able to see the tutors screen, ask questions real time and share their screen with the Tutor.

We have two decades of delivering technical training predominantly in the West Midlands. Some of our clients are Birmingham Heartlands Hospital, University of Birmingham, Royal Air Force, Loughborough University, Norwich Union PLC, Countrywide Homes Limited, Fujistu PLC and TalkTalk Direct Limited.

Microsoft SQL Server Integration Services SSIS

  • 2 day course
  • Location: Derby
  • 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 ...
  • Understanding Parameters SQL Server Integration Services Tools
    Administration of SQL Using the SQL Management Objects Tasks Data Flow
    Using the Best Practices Debugging SQL Server Integration Services Packages
    Utilizing Cache Modes in Joins Tuning SQL Server Integration Services Packages
    Utilizing Data Preparation Tasks
    Utilizing Connection Managers SQL Server Integration Services Tasks
    Understanding Variables
    Overview of Containers
    Choosing the Script Task or Script Component
    Handling Errors Common SQL Server Integration Services Design Patterns
    Utilizing Container Loops Performing Joins
    Understanding Deployment Strategies 
    Working with Advanced Logging and Reporting
    Using Destinations and Understanding choices
    Designing to Troubleshoot: Using Precedence Constraints
    Working in the Explore Window
    Data Loading with the Analysis Services Tasks
    The SQL Server Integration Service
    Examining the SSIS Engine
    Define and Use Variables and Parameters
    Utilizing Sequences in a Container

  • See Training Course Details...

Email us about this courses

Other Derby Enable Technology Training Courses

JQuery Derby Training Courses
Excel 365 Basic Derby Training Courses
Power BI - Derby Microsoft Power BI Training Courses