WHAT WE DO - Training & Mentoring

Implementing and Maintaining MS SQL Server 2005 Integration Services

dotted line
Implementing and Maintaining MS SQL Server 2005 Integration Services
(Course 2792 - 3 days)
Next public course: Nov 8 - 10

Register Now
dotted line
Learning Objectives & Approach:
After completing this course, students will be able to:
  • Describe SQL Server Integration Services and its tools.
  • Create an Integration Services package.
  • Implement control flow in an Integration Services package.
  • Implement data flow in an Integration Services package.
  • Implement logging in an Integration Services package.
  • Debug and implement error handling in an Integration Services package.
  • Implement checkpoints and transactions in an Integration Services package.
  • Deploy an Integration Services package.
  • Manage and secure an Integration Services package.
Key Topics:

Topics covered in this course include:

  • Introduction to SQL Server 2005 Integration Services
  • Developing Integration Services Solutions
  • Implementing Control Flow
  • Implementing Data Flow
  • Implementing Logging
  • Debugging and Error Handling
  • Implementing Checkpoints and Transactions
  • Deploying Packages
  • Managing and Securing Packages
Targeted Participants:
This course is intended for information technology (IT) professionals and developers who need to implement data transfer or extract, transform, and load (ETL) solutions by using Microsoft SQL Server 2005 Integration Services.
Prerequisites:
After completing this course, students will be able to:
  • Describe SQL Server Integration Services and its tools.
  • Create an Integration Services package.
  • Implement control flow in an Integration Services package.
  • Implement data flow in an Integration Services package.
  • Implement logging in an Integration Services package.
  • Debug and implement error handling in an Integration Services package.
  • Implement checkpoints and transactions in an Integration Services package.
  • Deploy an Integration Services package.
  • Manage and secure an Integration Services package.
Course Fee:
For public courses, $1,650.00 (CAD) per participant. Group rates are available for both public and private courses - please inquire.
Registration:
Courses can be held at your site, or on-site at our training facility located in downtown Calgary, Alberta (Canada). Your team can join a public course, or request a private session. To register for this course, use the "Register" link below.

Next public course: Nov 8 - 10
dotted line
Register Now
dotted line