Enable Technology



About Enable Technology Penarth SQL Server Integration Services Training Courses

Enable Technology provides practical SQL Server Integration Services skills based technology training. All Enable Technology tutors are Microsoft certified experts. All candidates receive comprehensive SQL Server Integration Services training materials and practice files which are theirs to refer to after the course. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with SQL Server Integration Services queries.

SQL Server Integration Services courses are taught by a Microsoft Certified Solutions Expert. Enable Technology can supply all of the equipment necessary to deliver SQL Server Integration Services courses onsite at your offices. You simply need to provide a suitable room. Another option is we can organise a local socially distanced training site in Penarth. We will work with you prior to the course to tailor the SQL Server Integration Services syllabus to match your 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. Our clients include: Birmingham City Council, Cadbury PLC, Birmingham Heartlands Hospital, West Bromwich Building Society, Unipart Group, Queen's Medical Centre Nottingham, EDF Energy PLC and Keele University.

Microsoft SQL Server Integration Services SSIS

  • 2 day course
  • Location: Penarth
  • 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 ...
  • Utilizing the Import/Export Wizard
    Handling Errors Common SQL Server Integration Services Design Patterns
    Using the Best Practices Debugging SQL Server Integration Services Packages
    Coding the Script Task
    Define and Use Variables and Parameters
    Managing SQL with the SQL Tasks
    Using Destinations and Understanding choices
    Utilizing Sequences in a Container
    Overview of Containers
    Designing to Troubleshoot: Using Precedence Constraints
    Looping and Sequence Tasks
    Managing with Control Flow
    Understanding Variables
    Performing Joins with the Lookup Transformation
    Examining the Transformation and Other Tasks Variables, Parameters and Expressions
    Understanding Packages
    Creating SQL Server Integration Services Packages
    Utilizing Container Loops Performing Joins
    Utilizing Connection Managers SQL Server Integration Services Tasks
    The SQL Server Integration Service
    Working with Advanced Logging and Reporting

  • See Training Course Details...

Email us about this courses

Other Penarth Enable Technology Training Courses

Excel 365 Advanced Penarth Training Courses
JQuery - Penarth JavaScript Training Courses
Excel 365 Basic - Penarth Excel Training Courses