Enable Technology



About Enable Technology Caerphilly SQL Server Integration Services Training Courses

We are a company that offers short, practical, SQL Server Integration Services hands on technology courses. All Enable Technology tutors are Microsoft certified experts. Every course participant will receives course practice files and SQL Server Integration Services course resources that can be referenced post training. We also provide an ongoing support service to people attending our SQL Server Integration Services courses. Delegates can contact the course tutor with specific SQL Server Integration Services questions for as long as they need following the course.

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. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the SQL Server Integration Services onsite. Another option is we can organise a local socially distanced training site in Caerphilly. The SQL Server Integration Services syllabus can be adjusted and additional topics incorporated if helpful.

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.

Our teaching team have been delivering technical training in the Midlands for twenty years. Our clients include: Barclays Bank PLC, GKN PLC, Unipart Group, Royal Air Force, Boots UK Limited, TalkTalk Direct Limited, EDF Energy PLC and Queen's Medical Centre Nottingham.

Microsoft SQL Server Integration Services SSIS

  • 2 day course
  • Location: Caerphilly
  • 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 Package Hierarchies: Parent Child
    Managing SQL with the SQL Tasks
    Understanding Deployment Strategies 
    Performing Joins with the Lookup Transformation
    Utilizing Connection Managers SQL Server Integration Services Tasks
    Choosing the Script Task or Script Component
    Data Loading with the Analysis Services Tasks
    Performing Joins with the Merge Transformation
    Using Expressions in Packages Containers
    Understanding Variables
    Using the Workflow Tasks
    Working with XML
    Working in the Explore Window
    Moving Data with Data Flow
    Utilizing the Import/Export Wizard
    Examining the Transformation and Other Tasks Variables, Parameters and Expressions
    SQL Server Integration Services Architecture
    Working with Advanced Logging and Reporting
    Define and Use Variables and Parameters
    Understanding Parameters SQL Server Integration Services Tools
    Designing to Troubleshoot: Using Precedence Constraints

  • See Training Course Details...

Email us about this courses

Other Caerphilly Enable Technology Training Courses

PL/SQL - Caerphilly SQL Training Courses
Excel 365 Basic Caerphilly Training Courses
Access Caerphilly Training Courses