Enable Technology



About Enable Technology Birmingham SQL Server Integration Services Training Courses

Enable Technology SQL Server Integration Services courses are short, skill focused and hands on. The course will always be taught by a Microsoft Certified Professional (MCP). Every person attending a SQL Server Integration Services course will be provided with training materials and practice files to retain after the course. Our policy is to provide open ended SQL Server Integration Services post training support to participants. This additional service is an important part ofhow we help people implement the skills they have learned in the workplace.

We provide instructor led training coupled with hands on training. We can deliver at your premises. We can provide the equipment. We also offer the option of scheduling of SQL Server Integration Services course at a socially distanced venue near you in Birmingham. 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.

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 operated primarily in the West Midlands for twenty years. Some of our clients are Lloyds TSB Bank PLC, Loughborough University, Shell UK Oil Products Ltd, EDF Energy PLC, Boots UK Limited, Unipart Group, Carillion PLC and South Staffordshire Water PLC.

Microsoft SQL Server Integration Services SSIS

  • 2 day course
  • Location: Birmingham
  • 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 ...
  • Working with XML
    Performing Joins with the Lookup Transformation
    Using Package Hierarchies: Parent Child
    Utilizing the Import/Export Wizard
    Using the Workflow Tasks
    Performing Joins with the Merge Transformation
    Coding the Script Task
    Designing to Troubleshoot: Using Precedence Constraints
    The SQL Server Integration Service
    Administration of SQL Using the SQL Management Objects Tasks Data Flow
    Working with Advanced Logging and Reporting
    Managing SQL with the SQL Tasks
    Examining the SSIS Engine
    Define and Use Variables and Parameters
    Using Destinations and Understanding choices
    Utilizing Data Preparation Tasks
    Examining the Transformation and Other Tasks Variables, Parameters and Expressions
    Utilizing Cache Modes in Joins Tuning SQL Server Integration Services Packages
    Understanding Deployment Strategies 
    Utilizing Connection Managers SQL Server Integration Services Tasks
    Using the Best Practices Debugging SQL Server Integration Services Packages

  • See Training Course Details...

Email us about this courses

Other Birmingham Enable Technology Training Courses

Access VBA Birmingham Training Courses
PL/SQL Birmingham Training Courses
TSQL Birmingham Training Courses