Enable Technology



About Enable Technology Sheffield SQL Server Integration Services Training Courses

We are a company that provides short intensive SQL Server Integration Services training courses. All Enable Technology tutors are Microsoft certified experts. All candidates receive comprehensive SQL Server Integration Services training materials and practice files which are theirs to refer to after the course. Course participants are welcome contact the Tutor after the course with specific SQL Server Integration Services queries. This support is open ended.

Enable Technology SQL Server Integration Services courses are instructor led and taught by an experienced Microsoft expert. We can set up a training lab at your premises and deliver SQL Server Integration Services courses onsite at your site. The SQL Server Integration Services course could also be scheduled at a socially distanced site near you in Sheffield. We are happy to discuss customising the course content should you have particular SQL Server Integration Services 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.

The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Some of our clients are Fujistu PLC, Barclays Bank PLC, Unipart Group, Norfolk Police Constabulary, University of Birmingham, TalkTalk Direct Limited, Birmingham City Council and Capita Group PLC.

Microsoft SQL Server Integration Services SSIS

  • 2 day course
  • Location: Sheffield
  • 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
    Define and Use Variables and Parameters
    Managing with Control Flow
    Optimizing Sources for Extraction
    Utilizing Cache Modes in Joins Tuning SQL Server Integration Services Packages
    Designing to Troubleshoot: Using Precedence Constraints
    Working with Advanced Logging and Reporting
    Working in the Explore Window
    Understanding Parameters SQL Server Integration Services Tools
    Looping and Sequence Tasks
    Choosing the Script Task or Script Component
    Utilizing the Import/Export Wizard
    Utilizing Connection Managers SQL Server Integration Services Tasks
    Data Loading with the Analysis Services Tasks
    Utilizing Container Loops Performing Joins
    Managing SQL with the SQL Tasks
    The SQL Server Integration Service
    Using Package Hierarchies: Parent Child
    Performing Joins with the Lookup Transformation
    Utilizing Sequences in a Container
    Using Expressions in Packages Containers

  • See Training Course Details...

Email us about this courses

Other Sheffield Enable Technology Training Courses

Access Sheffield Training Courses
JQuery - Sheffield JavaScript Training Courses
VBA Sheffield Training Courses