Enable Technology



About Enable Technology Lancashire SQL Server Integration Services Training Courses

Enable Technology offer short intensive skills based SQL Server Integration Services training courses. The person delivering the course will be a Microsoft Solutions Expert (MCSE). Each person attending a course takes away SQL Server Integration Services courseware which can be used as reference materials after the training. Course participants are welcome contact the Tutor after the course with specific SQL Server Integration Services queries. This support is open ended.

We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the SQL Server Integration Services onsite. We are also more than happy to organise a local course at a socially distanced training location in Lancashire. The Enable Technology approach is to discuss your requirements prior to the course. Every onsite SQL Server Integration Services course to some extent is bespoke and tailored to your needs.

We also deliver this course online through virtual classrooms. Delegates can join scheduled SQL Server Integration Services classes, view the tutors demonstrations, ask questions and share their screen with the trainer if they need assistance.

We have operated primarily in the West Midlands for twenty years. Some of our clients are Capita Group PLC, Nationwide Building Society Limited, Birmingham City Council, Barclays Bank PLC, West Bromwich Building Society, Loughborough University, Halfords Group PLC and Lloyds TSB Bank PLC.

Microsoft SQL Server Integration Services SSIS

  • 2 day course
  • Location: Lancashire
  • 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 ...
  • Using Destinations and Understanding choices
    Coding the Script Task
    Overview of Containers
    Looping and Sequence Tasks
    Performing Joins with the Lookup Transformation
    Utilizing Data Preparation Tasks
    Understanding Parameters SQL Server Integration Services Tools
    Designing to Troubleshoot: Using Precedence Constraints
    Utilizing Connection Managers SQL Server Integration Services Tasks
    Utilizing Container Loops Performing Joins
    Performing Joins with the Merge Transformation
    Utilizing SQL Server Integration Services Data Typing
    Working in the Explore Window
    Using Expressions in Packages Containers
    The SQL Server Integration Service
    SQL Server Integration Services Architecture
    Moving Data with Data Flow
    Utilizing Cache Modes in Joins Tuning SQL Server Integration Services Packages
    Choosing the Script Task or Script Component
    Define and Use Variables and Parameters
    Handling Errors Common SQL Server Integration Services Design Patterns

  • See Training Course Details...

Email us about this courses

Other Lancashire Enable Technology Training Courses

SSRS Lancashire Training Courses
Power Query - Lancashire Excel Training Courses
Report Builder Lancashire Training Courses