Enable Technology



About Enable Technology Cardiff SQL Server Integration Services Training Courses

Enable Technology SQL Server Integration Services courses are short, skill focused and hands on. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. All course participants are issued SQL Server Integration Services training manuals they can refer to 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.

SQL Server Integration Services training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. We are set up to deliver SQL Server Integration Services training courses onsite at your premises. We also offer the option of scheduling of SQL Server Integration Services course at a socially distanced venue near you in Cardiff. The SQL Server Integration Services syllabus can be modified to accommodate your specific training needs.

We can also deliver SQL Server Integration Services courses through an online virtual classroom. You log onto a scheduled virtual classroom, can view the tutor and exercise demonstrations, ask questions and allow the tutor to share your screen if need help completing the course exercises.

Our teaching team have been delivering technical training in the Midlands for twenty years. Our clients include: Barclays Bank PLC, GKN PLC, Wolverhampton City Council, Keele University, Yell Group PLC, Lloyds TSB Bank PLC, Nuclear Engineering Services and Loughborough University.

Microsoft SQL Server Integration Services SSIS

  • 2 day course
  • Location: Cardiff
  • 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 ...
  • Working in the Explore Window
    Designing to Troubleshoot: Using Precedence Constraints
    Using Destinations and Understanding choices
    Using the Best Practices Debugging SQL Server Integration Services Packages
    Overview of Containers
    Handling Errors Common SQL Server Integration Services Design Patterns
    Understanding Parameters SQL Server Integration Services Tools
    Examining the Transformation and Other Tasks Variables, Parameters and Expressions
    Working with XML
    Performing Joins with the Lookup Transformation
    Utilizing the Import/Export Wizard
    Understanding Packages
    Optimizing Sources for Extraction
    Managing SQL with the SQL Tasks
    Working with Advanced Logging and Reporting
    Creating Dynamic Packages
    Utilizing Sequences in a Container
    Utilizing SQL Server Integration Services Data Typing
    Choosing the Script Task or Script Component
    Looping and Sequence Tasks
    Utilizing Container Loops Performing Joins

  • See Training Course Details...

Email us about this courses

Other Cardiff Enable Technology Training Courses

SQL - Cardiff SQL Training Courses
TSQL - Cardiff SQL Training Courses
Power Query Cardiff Training Courses