6235 Implementing and Maintaining Microsoft SQL Server 2008 Integration Services

Course Categorization:
Microsoft,
Databases,
Course Provider:
New Horizons Computer Learning Centers
Learning Method:
Classroom Learning
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.

Lesson 1: Introduction to SQL Server 2008 Integration Services

  • Overview of SQL Server Integration Services
  • Using Integration Services Tools

Lesson 2: : Developing Integration Services Solutions

  • Creating an Integration Services Solution
  • Using Variables
  • Building and Running a Solution

Lesson 3: Implementing Control Flow

  • Control Flow Tasks
  • Control Flow Precedent Constraints
  • Control Flow Containers

Lesson 4: Implementing Data Flow

  • Data Flow Sources and Destinations
  • Basic Data Flow Transformations
  • Advanced Data Flow Transformations
  • Data Flow Paths

Lesson 5: Implementing Logging

  • Overview of Integration Services Logging
  • Using Logging

Lesson 6: Debugging and Error Handling

  • Debugging a Package
  • Implementing Error Handling

Lesson 7: Implementing Checkpoints and Transactions

  • Implementing Checkpoints
  • Implementing Transactions

Lesson 8: Configuring and Deploying Packages

  • Package Configurations
  • Preparing and Deploying Packages

Lesson 9: Managing and Securing Packages

  • Managing Packages
  • Securing Packages
  • Charleston, SC - April 23, 2012
  • Columbia, SC - April 23, 2012
  • Greenville, SC - April 23, 2012
  • Chattanooga, TN - April 23, 2012
  • Charleston, WV - April 23, 2012
  • West Valley City, UT - April 23, 2012
  • Troy, MI - April 23, 2012
  • Westerville, OH - April 25, 2012
  • Greensboro, NC - April 30, 2012
  • Mechanicsburg, PA - April 30, 2012
  • Jacksonville, FL - May 2, 2012
  • Las Vegas, NV - May 21, 2012
  • Sacramento, CA - May 21, 2012
  • Reno, NV - May 21, 2012
  • San Bernardino, CA - May 23, 2012
  • Charleston, SC - May 30, 2012
  • Columbia, SC - May 30, 2012
  • Greenville, SC - May 30, 2012
  • Charleston, WV - May 30, 2012
  • Garfield Heights, OH - June 4, 2012
  • Greensboro, NC - June 11, 2012
  • Atlanta, GA - June 12, 2012
  • Urbandale, IA - June 13, 2012
  • Charleston, SC - June 25, 2012
  • Columbia, SC - June 25, 2012
  • Greenville, SC - June 25, 2012
  • Charleston, WV - June 25, 2012
  • Madison, WI - June 25, 2012
  • Madison, WI - July 9, 2012
  • Las Vegas, NV - July 16, 2012

People Also Registered For

6231 Maintaining a Microsoft SQL Server 2008 R2 Database

This course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2008 R2 database. The course focuses on teaching individuals how to use SQL Server 2008 R2 product...

6236 Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services

This course teaches students how to implement a Reporting Services solution in an organization. The course discusses how to use the development tools to create reports, and how to use the...

2778 Writing Queries Using Microsoft SQL Server 2008 Transact-SQL

This course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2008.

6234 Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services

This course teaches students how to implement an Analysis Services solution in an organization. The course discusses how to use the Analysis Services development tools to create an Analysis...

SQL Querying - Level 2 Advanced Querying

In this course, students will work with advanced queries to manipulate and index tables. Students will also create transactions so that you can choose to save or cancel data entry process.

50429 SharePoint 2010 Business Intelligence

This course explores how to use SharePoint as your platform for Business Intelligence. Journey through the SharePoint Business Intelligence Center, Excel Services, Reporting Services, Analysis...

Related Courses

10337 Updating Your Microsoft SQL Server 2008 BI Skills to SQL Server 2008 R2

This course focuses on the new features SQL Server 2008 R2 for BI specialists.

50027 Querying and Processing SQL Server Data with SQL Statements

This course concentrates on providing students with the knowledge and skills necessary to exploit the features and functions available in SQL Server.

6158 Updating Your SQL ServerĀ® 2005 Skills to SQL Server 2008

This course provides students with the knowledge and skills to upgrade their SQL Server 2005 skills to SQL Server 2008.

2778 Writing Queries Using Microsoft SQL Server 2008 Transact-SQL

This course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2008.

2793 Implementing and Maintaining Microsoft SQL Server 2005 Reporting Services

This course teaches how to implement a Reporting Services solution in an organization. The course discusses how to use the Reporting Services development tools to create reports, and how to use...

6231 Maintaining a Microsoft SQL Server 2008 R2 Database

This course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2008 R2 database. The course focuses on teaching individuals how to use SQL Server 2008 R2 product...

6232 Implementing a Microsoft SQL Server 2008 R2 Database

This course is intended for Microsoft SQL Server database developers who are responsible for implementing a database on SQL Server 2008 R2. In this course, students learn the skills and best...

6234 Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services

This course teaches students how to implement an Analysis Services solution in an organization. The course discusses how to use the Analysis Services development tools to create an Analysis...

6235 Implementing and Maintaining Microsoft SQL Server 2008 Integration Services

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.

6236 Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services

This course teaches students how to implement a Reporting Services solution in an organization. The course discusses how to use the development tools to create reports, and how to use the...