Enable Technology



About Enable Technology Gateshead SQL Server Integration Services Training Courses

We are company which specialises in short, two and three day intensive SQL Server Integration Services technology training courses. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. Each person attending a course takes away SQL Server Integration Services courseware which can be used as reference materials after the 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.

Enable Technology training courses are delivered as instructor led courses. We are set up to deliver SQL Server Integration Services training courses onsite at your premises. We are also more than happy to organise a local course at a socially distanced training location in Gateshead. We are happy to modify the SQL Server Integration Services syllabus to match your teams training requirements.

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: Norfolk Police Constabulary, Unipart Group, Shell UK Oil Products Ltd, Birmingham City Council, Capita Group PLC, Dollond & Aitchison Limited, Birmingham City University and Total Telecommunications Limited.

Microsoft SQL Server Integration Services SSIS

  • 2 day course
  • Location: Gateshead
  • 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 ...
  • Overview of Containers
    Moving Data with Data Flow
    Using the Best Practices Debugging SQL Server Integration Services Packages
    Optimizing Sources for Extraction
    Choosing the Script Task or Script Component
    Performing Joins with the Lookup Transformation
    Working in the Explore Window
    Managing SQL with the SQL Tasks
    Utilizing the Import/Export Wizard
    Utilizing Data Preparation Tasks
    Define and Use Variables and Parameters
    Handling Errors Common SQL Server Integration Services Design Patterns
    Using the Workflow Tasks
    Coding the Script Task
    Managing with Control Flow
    Data Loading with the Analysis Services Tasks
    Using Package Hierarchies: Parent Child
    Administration of SQL Using the SQL Management Objects Tasks Data Flow
    Utilizing Container Loops Performing Joins
    Working with XML
    Using Expressions in Packages Containers

  • See Training Course Details...

Email us about this courses

Other Gateshead Enable Technology Training Courses

SSAS Gateshead Training Courses
Data Warehouse Gateshead Training Courses
VBA - Gateshead Excel Training Courses