Course details

Overview

This course teaches students how to implement an Integration Services solution in an organization. The course discusses how to develop, deploy, and manage Integration Services packages.

Who Should Attend

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 2008 Integration Services.

Prerequisite Comments

  • Experience navigating the Microsoft Windows Server environment.
  • Experience with Windows services (starting and stopping)

Experience creating service accounts and permissionsExperience with Microsoft SQL ServerConceptual understanding of OLAP solutions.

Outline

  • Lesson 1: Introduction to SQL Server 2008 Integration Services
  • Lesson 2: : Developing Integration Services Solutions
  • Lesson 3: Implementing Control Flow
  • Lesson 4: Implementing Data Flow
  • Lesson 5: Implementing Logging
  • Lesson 6: Debugging and Error Handling
  • Lesson 7: Implementing Checkpoints and Transactions
  • Lesson 8: Configuring and Deploying Packages
  • Lesson 9: Managing and Securing Packages
Updated on 08 November, 2015

About IT & Business Consulting Group

Whether you need a one-day onsite training course, full-service consulting, or if you are not really sure which solution will work, we can help.
ITBCG is a leading and innovative learning provider with over twenty years’ experience of providing best in-class learning solutions. We work in partnership with our customers to deliver flexibility, value and service. We develop innovative programs to ensure that every aspect of the learning development, delivery and administration of courses work to our clients’ benefit.
We provide IT and business skills learning to both the private and public sector companies and organizations. Our core training is focused on Cisco, Microsoft, CompTIA Citrix, EC-Council, Oracle, and ISC2 and best practice. This includes ITIL® Service Management and ISO, and PMI which is tied into business process improvement, project management, and business analysis and leadership development.
See all IT & Business Consulting Group courses
Are you from IT & Business Consulting Group ? Claim your course!
Courses you can instantly connect with... Do an online course on SQL Server starting now. See all courses

Is this the right course for you?

Didn't find what you were looking for ?

or