Enable Technology



About Enable Technology Farnworth SQL Server Integration Services Training Courses

We offer intensive two and three days SQL Server Integration Services courses. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. We will issue each SQL Server Integration Services training participant with learning resources which they can refer to post training. Enable Technology offer post course help to all delegates. Participants on the SQL Server Integration Services course can contact the tutor for as long as they like if they encounter SQL Server Integration Services problems.

We provide instructor led training coupled with hands on training. We can deliver at your premises. We can provide the equipment. Alternatively we could schedule a course at a local socially distanced venue in Farnworth. 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.

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 over twenty years continuous technical training experience. Our clients include: Boots UK Limited, West Bromwich Building Society, Birmingham City University, Lloyds TSB Bank PLC, DHL Express, Nuclear Engineering Services, Yell Group PLC and Keele University.

Microsoft SQL Server Integration Services SSIS

  • 2 day course
  • Location: Farnworth
  • 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 ...
  • Utilizing the Import/Export Wizard
    Examining the SSIS Engine
    Administration of SQL Using the SQL Management Objects Tasks Data Flow
    Using Destinations and Understanding choices
    Understanding Packages
    Looping and Sequence Tasks
    Using Expressions in Packages Containers
    Managing with Control Flow
    Utilizing Connection Managers SQL Server Integration Services Tasks
    Creating SQL Server Integration Services Packages
    SQL Server Integration Services Architecture
    Performing Joins with the Merge Transformation
    Working with XML
    Using the Best Practices Debugging SQL Server Integration Services Packages
    Utilizing Data Preparation Tasks
    Handling Errors Common SQL Server Integration Services Design Patterns
    Understanding Deployment Strategies 
    Utilizing Sequences in a Container
    Choosing the Script Task or Script Component
    Define and Use Variables and Parameters
    Coding the Script Task

  • See Training Course Details...

Email us about this courses

Other Farnworth Enable Technology Training Courses

Excel 365 Basic - Farnworth Excel Training Courses
Power BI - Farnworth Microsoft Power BI Training Courses
DAX Farnworth Training Courses