Enable Technology

SQL SERVER INTEGRATION SERVICES LANCASTER TRAINING COURSES 

SQL SERVER INTEGRATION SERVICES TRAINING COURSES LANCASTER




About Enable Technology Lancaster SQL Server Integration Services Training Courses

We are a company that provides short intensive SQL Server Integration Services training courses. The tutor delivering the course will be a Microsoft certified expert. All course participants are issued SQL Server Integration Services training manuals they can 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.

Our primary method of delivery is instructor led training coupled with practical hands on activities. 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 Lancaster. The SQL Server Integration Services syllabus can be modified to accommodate your specific training 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.

In the Midlands the Enable Technology team have been providing technical training since 1998. Our clients include: Birmingham City Council, TalkTalk Direct Limited, Boots UK Limited, Nationwide Building Society Limited, GKN PLC, Wolverhampton City Council, Norwich Union PLC and DHL Express.




Microsoft SQL Server Integration Services SSIS

  • 2 day course
  • Location: Lancaster
  • 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 ...
  • Optimizing Sources for Extraction
    Looping and Sequence Tasks
    Utilizing Connection Managers SQL Server Integration Services Tasks
    Using the Best Practices Debugging SQL Server Integration Services Packages
    Working with XML
    Designing to Troubleshoot: Using Precedence Constraints
    Creating SQL Server Integration Services Packages
    Understanding Parameters SQL Server Integration Services Tools
    Overview of Containers
    Using Expressions in Packages Containers
    Define and Use Variables and Parameters
    The SQL Server Integration Service
    Choosing the Script Task or Script Component
    Working with Advanced Logging and Reporting
    Performing Joins with the Lookup Transformation
    Managing SQL with the SQL Tasks
    Administration of SQL Using the SQL Management Objects Tasks Data Flow
    Understanding Deployment Strategies 
    Utilizing Data Preparation Tasks
    Examining the Transformation and Other Tasks Variables, Parameters and Expressions
    Examining the SSIS Engine

  • See Training Course Details...



Email us about this courses



Other Lancaster Enable Technology Training Courses

JQuery Mobile - Lancaster JavaScript Training Courses
Power BI Lancaster Training Courses
Access VBA - Lancaster Access Training Courses