SQL SERVER INTEGRATION SERVICES TRAINING COURSES LICHFIELD
About Enable Technology Lichfield SQL Server Integration Services Training Courses
Enable Technology SQL Server Integration Services courses are short, skill focused and hands on. The tutor teaching the course will be an experienced developer and Microsoft certified professional. All course participants are issued SQL Server Integration Services training manuals they can refer to after the course. Anyone attending the course can contact the Tutor for as long as they like after the SQL Server Integration Services course. The ongoing support by a Microsoft expert is an important part of the service we offer.
We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. Enable Technology can provide SQL Server Integration Services courses onsite at your location. We will bring the necessary laptops with the required software installed. Another option is we can organise a local training site in Lichfield. We are happy to discuss customising the course content should you have particular SQL Server Integration Services training requirements.
We also deliver this course online through virtual classrooms. Delegates can join scheduled SQL Server Integration Services classes, view the tutors demonstrations, ask questions and share their screen with the trainer if they need assistance.
Our teaching team have over twenty years continuous technical training experience. Some of our clients are Halfords Group PLC, Nationwide Building Society Limited, Birmingham City University, Loughborough University, Vodafone Group Services, Royal Air Force, National Power PLC and Total Telecommunications Limited.
Microsoft SQL Server Integration Services SSIS
- 2 day course
- Location: Lichfield
- 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
- See Training Course Details...
Using Destinations and Understanding choices
Define and Use Variables and Parameters
Creating Dynamic Packages
Managing SQL with the SQL Tasks
Looping and Sequence Tasks
Coding the Script Task
Using the Best Practices Debugging SQL Server Integration Services Packages
SQL Server Integration Services Architecture
Utilizing Connection Managers SQL Server Integration Services Tasks
Examining the Transformation and Other Tasks Variables, Parameters and Expressions
Handling Errors Common SQL Server Integration Services Design Patterns
Utilizing Sequences in a Container
Managing with Control Flow
Performing Joins with the Lookup Transformation
Using Package Hierarchies: Parent Child
Moving Data with Data Flow
The SQL Server Integration Service
Designing to Troubleshoot: Using Precedence Constraints
Creating SQL Server Integration Services Packages
Working with XML
Email us about this courses
Other Lichfield Enable Technology Training Courses
SSAS - Lichfield SQL Server Analysis Services Training Courses
JavaScript Lichfield Training Courses
SQL Lichfield Training Courses