SQL SERVER INTEGRATION SERVICES TRAINING COURSES POWYS
About Enable Technology Powys SQL Server Integration Services Training Courses
Enable Technology has twenty year track record of providing short intensive SQL Server Integration Services skills based training courses. The course will always be taught by a Microsoft Certified Professional (MCP). Everyone attending a SQL Server Integration Services course receives learning resources which also serves as a reference source after the course. We offer a post training support service and delegates will have access to a Microsoft expert on SQL Server Integration Services for as long as they need.
SQL Server Integration Services training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the SQL Server Integration Services onsite. If delivery onsite is an issue we will organise a venue near you in Powys. 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.
This instructor led course is also available online. Participants can log onto a virtual classroom and will be able to see the tutors screen, ask questions real time and share their screen with the Tutor.
Our teaching team have over twenty years continuous technical training experience. Our clients include: Birmingham City Council, Wolverhampton City Council, Dollond & Aitchison Limited, Nuclear Engineering Services, Vodafone Group Services, Capita Group PLC, EDF Energy PLC and Unipart Group.
Microsoft SQL Server Integration Services SSIS
- 2 day course
- Location: Powys
- 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 ... Utilizing the Import/Export Wizard
- See Training Course Details...
Using the Workflow Tasks
Coding the Script Task
SQL Server Integration Services Architecture
Moving Data with Data Flow
Managing SQL with the SQL Tasks
Optimizing Sources for Extraction
Utilizing Connection Managers SQL Server Integration Services Tasks
Using Package Hierarchies: Parent Child
Using Expressions in Packages Containers
Utilizing Cache Modes in Joins Tuning SQL Server Integration Services Packages
Creating Dynamic Packages
Creating SQL Server Integration Services Packages
Data Loading with the Analysis Services Tasks
Working with Advanced Logging and Reporting
Performing Joins with the Merge Transformation
Using the Best Practices Debugging SQL Server Integration Services Packages
Performing Joins with the Lookup Transformation
Handling Errors Common SQL Server Integration Services Design Patterns
Designing to Troubleshoot: Using Precedence Constraints
Understanding Parameters SQL Server Integration Services Tools
Email us about this courses
Other Powys Enable Technology Training Courses
Excel 365 Intermediate Powys Training Courses
Excel 365 Basic Powys Training Courses
JavaScript - Powys JavaScript Training Courses