Overview
This three-day, instructor-led course provides students with the knowledge and skills necessary to implement an Integration Services solution in an organisation.
What’s Included?
All our public scheduled training courses offer delegates the following facilities which are all included at no extra cost: -
Mini Continental Breakfast, with a choice of Croissants, Pastries, Cereals, Juices, and of course Tea and Coffee
Buffet Lunch
A Selection of Soft Beverages are available throughout the Training Day
Full Course Manual (Official Curriculum Courseware for Technical Courses)
Course Exercise Files on CD or Floppy Disk
Course Stationery Pack (Pen, Pencil and Paper)
Framed Course Certificate (Vendor Accredited where required)
Objectives
At the end of the course, students will be able to:
Describe SQL Server 2005 Integration Services
Develop Integration Services Solutions
Implement Control Flow
Implement Data Flow
Implement Logging
Debug and Handle Errors
Implement Checkpoints and Transactions
Deploy Packages
Manage and Secure Packages
Audience
This course is intended for Information Technology Professionals and Developers who need to implement Data Transfer or Extract, Transform and Load Solutions by using Microsoft SQL Server 2005 Integration Services.
Prerequisites
Before attending this course, students must have:
Exposure to Enterprise Data Import and Export Scenarios
Experience navigating the Microsoft Windows Server Environment