Enable Technology

SQL SERVER INTEGRATION SERVICES BURNLEY TRAINING COURSES 

SQL SERVER INTEGRATION SERVICES TRAINING COURSES BURNLEY




About Enable Technology Burnley 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. All of our tutors are Microsoft Certified Professionals. All course participants are issued SQL Server Integration Services training manuals they can refer to 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.

Delegates are taught by an experienced Microsoft professional. SQL Server Integration Services courses are delivered through a mix of practical hands on exercises and walk throughs. Enable Technology can provide SQL Server Integration Services courses onsite at your location. We will bring the necessary laptops with the required software installed. If you prefer we can offer an offsite training location in Burnley. All SQL Server Integration Services courses can be customised to meet your particular requirements.

We can also deliver SQL Server Integration Services courses through an online virtual classroom. You log onto a scheduled virtual classroom, can view the tutor and exercise demonstrations, ask questions and allow the tutor to share your screen if need help completing the course exercises.

The Enable Technology group of companies has been operating continuously providing IT training since 1998. Some of our clients are EDF Energy PLC, Norwich Union PLC, Unipart Group, Royal & Sun Alliance Group PLC, Birmingham Heartlands Hospital, Canadian High Commission, South Staffordshire Water PLC and Loughborough University.




Microsoft SQL Server Integration Services SSIS

  • 2 day course
  • Location: Burnley
  • 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 ...
  • Designing to Troubleshoot: Using Precedence Constraints
    Using the Workflow Tasks
    Working with XML
    Utilizing Connection Managers SQL Server Integration Services Tasks
    Examining the Transformation and Other Tasks Variables, Parameters and Expressions
    Creating SQL Server Integration Services Packages
    Using Destinations and Understanding choices
    Using Package Hierarchies: Parent Child
    Define and Use Variables and Parameters
    Working in the Explore Window
    Working with Advanced Logging and Reporting
    Examining the SSIS Engine
    Performing Joins with the Lookup Transformation
    Handling Errors Common SQL Server Integration Services Design Patterns
    Utilizing Cache Modes in Joins Tuning SQL Server Integration Services Packages
    Understanding Deployment Strategies 
    Choosing the Script Task or Script Component
    Using the Best Practices Debugging SQL Server Integration Services Packages
    Using Expressions in Packages Containers
    Optimizing Sources for Extraction
    The SQL Server Integration Service

  • See Training Course Details...



Email us about this courses



Other Burnley Enable Technology Training Courses

Oracle SQL - Burnley SQL Training Courses
DAX - Burnley Excel Training Courses
Power BI - Burnley Microsoft Power BI Training Courses