Enable Technology



About Enable Technology Hexham 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 Professionals. Each person attending a course takes away SQL Server Integration Services courseware which can be used as reference materials after the training. It is our policy to support delegates apply their new skill after the course. All candidate will be able to contact the course Tutor for as long as they feel they need help.

Our primary method of delivery is instructor led training coupled with practical hands on activities. We can set up a training lab at your premises and deliver SQL Server Integration Services courses onsite at your site. Another way we could deliver the SQL Server Integration Services course is at a local socially distanced training site. All SQL Server Integration Services courses can be customised to meet your particular requirements.

Taught SQL Server Integration Services courses are also available online. Course participants can join a a virtual classroom. They can talk to the tutor, share their screen and watch the tutor demonstrate each topic.

We have two decades of delivering technical training predominantly in the West Midlands. Our clients include: TalkTalk Direct Limited, National Power PLC, Norwich Union PLC, University of Birmingham, Homeserve PLC, Shell UK Oil Products Ltd, Total Telecommunications Limited and South Staffordshire Water PLC.

Microsoft SQL Server Integration Services SSIS

  • 2 day course
  • Location: Hexham
  • 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 ...
  • Creating SQL Server Integration Services Packages
    Utilizing Container Loops Performing Joins
    Working with Advanced Logging and Reporting
    Utilizing Cache Modes in Joins Tuning SQL Server Integration Services Packages
    Examining the Transformation and Other Tasks Variables, Parameters and Expressions
    Optimizing Sources for Extraction
    Understanding Deployment Strategies 
    Utilizing SQL Server Integration Services Data Typing
    Administration of SQL Using the SQL Management Objects Tasks Data Flow
    Utilizing Data Preparation Tasks
    Define and Use Variables and Parameters
    Performing Joins with the Merge Transformation
    Working with XML
    Handling Errors Common SQL Server Integration Services Design Patterns
    Using Package Hierarchies: Parent Child
    Examining the SSIS Engine
    Using the Workflow Tasks
    The SQL Server Integration Service
    Data Loading with the Analysis Services Tasks
    Understanding Parameters SQL Server Integration Services Tools
    Using the Best Practices Debugging SQL Server Integration Services Packages

  • See Training Course Details...

Email us about this courses

Other Hexham Enable Technology Training Courses

JavaScript Hexham Training Courses
Power BI Hexham Training Courses
Power Query Hexham Training Courses