Enable Technology

SQL SERVER INTEGRATION SERVICES SHEFFIELD TRAINING COURSES 

SQL SERVER INTEGRATION SERVICES TRAINING COURSES SHEFFIELD




About Enable Technology Sheffield SQL Server Integration Services Training Courses

We have a twenty year history of providing skills based SQL Server Integration Services industry training. The course will always be taught by a Microsoft Certified Professional (MCP). We provide every candidate with SQL Server Integration Services training materials which they keep after the course. It is our company policy to provide SQL Server Integration Services training participants with ongoing support from the course Tutor. People who attend a SQL Server Integration Services course can contact the Tutor for as long as they need assistance after the training.

We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. We are set up to deliver SQL Server Integration Services training courses onsite at your premises. Alternatively we could schedule a SQL Server Integration Services course at an alternative training site in Sheffield. All SQL Server Integration Services courses can be customised to meet your particular requirements.

This course can also be delivered in a virtual classroom. Delegates can log into a scheduled SQL Server Integration Services course, watch the tutor demonstrate tasks, ask questions and share their own screen.

We guarantee you tutor will have at least twenty years of technical training experience. Some of our clients are University of Birmingham, Nuclear Engineering Services, Norfolk Police Constabulary, Aston University, Total Telecommunications Limited, GKN PLC, Capita Group PLC and Carillion PLC.




Microsoft SQL Server Integration Services SSIS

  • 2 day course
  • Location: Sheffield
  • 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 ...
  • Performing Joins with the Merge Transformation
    Understanding Variables
    Data Loading with the Analysis Services Tasks
    Using the Workflow Tasks
    Utilizing the Import/Export Wizard
    Using Destinations and Understanding choices
    Managing with Control Flow
    Working with XML
    Looping and Sequence Tasks
    Overview of Containers
    Working with Advanced Logging and Reporting
    Managing SQL with the SQL Tasks
    Utilizing SQL Server Integration Services Data Typing
    Choosing the Script Task or Script Component
    Using the Best Practices Debugging SQL Server Integration Services Packages
    Handling Errors Common SQL Server Integration Services Design Patterns
    Coding the Script Task
    Examining the Transformation and Other Tasks Variables, Parameters and Expressions
    Utilizing Cache Modes in Joins Tuning SQL Server Integration Services Packages
    Utilizing Data Preparation Tasks
    Optimizing Sources for Extraction

  • See Training Course Details...



Email us about this courses



Other Sheffield Enable Technology Training Courses

VBA Sheffield Training Courses
DAX Sheffield Training Courses
PL/SQL Sheffield Training Courses