Enable Technology



About Enable Technology West Midlands SQL Server Integration Services Training Courses

We offer intensive two and three days SQL Server Integration Services courses. The course will always be taught by a Microsoft Certified Professional (MCP). All candidates receive comprehensive SQL Server Integration Services training materials and practice files which are theirs to refer to after the course. 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.

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. Another way we could deliver the SQL Server Integration Services course is at a local socially distanced training site. We are happy to modify the SQL Server Integration Services syllabus to match your teams training requirements.

SQL Server Integration Services courses are available via virtual classrooms. Training participants can log onto scheduled classes, watch the tutor talk through and demonstrate each topic, ask questions and share their screen with the tutor if they need assistance.

Our teaching team have been delivering technical training in the Midlands for twenty years. Our clients include: Shell UK Oil Products Ltd, Halfords Group PLC, Aston University, Birmingham City Council, Dollond & Aitchison Limited, Countrywide Homes Limited, Homeserve PLC and EDF Energy PLC.

Microsoft SQL Server Integration Services SSIS

  • 2 day course
  • Location: West Midlands
  • 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 ...
  • Understanding Parameters SQL Server Integration Services Tools
    Creating Dynamic Packages
    Utilizing Sequences in a Container
    Designing to Troubleshoot: Using Precedence Constraints
    SQL Server Integration Services Architecture
    Choosing the Script Task or Script Component
    Working in the Explore Window
    Performing Joins with the Merge Transformation
    Using the Workflow Tasks
    Coding the Script Task
    Utilizing the Import/Export Wizard
    Overview of Containers
    Using Destinations and Understanding choices
    Working with XML
    Using Expressions in Packages Containers
    Administration of SQL Using the SQL Management Objects Tasks Data Flow
    Performing Joins with the Lookup Transformation
    Understanding Deployment Strategies 
    Data Loading with the Analysis Services Tasks
    Understanding Variables
    Working with Advanced Logging and Reporting

  • See Training Course Details...

Email us about this courses

Other West Midlands Enable Technology Training Courses

JQuery Mobile - West Midlands JavaScript Training Courses
Access VBA West Midlands Training Courses
Excel 365 Intermediate West Midlands Training Courses