Enable Technology



About Enable Technology Cwmbran SQL Server Integration Services Training Courses

We offer intensive two and three days SQL Server Integration Services courses. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. Every person attending a SQL Server Integration Services course will be provided with training materials and practice files to retain after the course. If delegates have have questions about SQL Server Integration Services after the course they are welcome to contact the course Tutor. This post training support is ongoing.

Enable Technology offers instructor led training taught by technology specialists. Our SQL Server Integration Services training courses can be delivered onsite at your location. You simply need to provide a room. We can supply the equipment and software. We are also more than happy to organise a local course at a socially distanced training location in Cwmbran. 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.

This instructor led SQL Server Integration Services training is also available online. Participants can see the tutors screen, ask questions and share their screen with the tutor.

The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Some of our clients are Nationwide Building Society Limited, TalkTalk Direct Limited, Countrywide Homes Limited, Homeserve PLC, Aston University, National Power PLC, Loughborough University and University of Birmingham.

Microsoft SQL Server Integration Services SSIS

  • 2 day course
  • Location: Cwmbran
  • 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 Expressions in Packages Containers
    Utilizing Connection Managers SQL Server Integration Services Tasks
    Utilizing the Import/Export Wizard
    Optimizing Sources for Extraction
    Understanding Parameters SQL Server Integration Services Tools
    SQL Server Integration Services Architecture
    Performing Joins with the Lookup Transformation
    Utilizing Cache Modes in Joins Tuning SQL Server Integration Services Packages
    Creating Dynamic Packages
    Utilizing Data Preparation Tasks
    Performing Joins with the Merge Transformation
    Managing with Control Flow
    Understanding Deployment Strategies 
    Data Loading with the Analysis Services Tasks
    Using the Workflow Tasks
    Administration of SQL Using the SQL Management Objects Tasks Data Flow
    Working with XML
    Using Package Hierarchies: Parent Child
    Using the Best Practices Debugging SQL Server Integration Services Packages
    Define and Use Variables and Parameters
    Choosing the Script Task or Script Component

  • See Training Course Details...

Email us about this courses

Other Cwmbran Enable Technology Training Courses

SSAS Tabular Cwmbran Training Courses
Access - Cwmbran Access Training Courses
Excel 365 Intermediate - Cwmbran Excel Training Courses