SQL Server
 
 
 

Up And Running With SSIS 2005 (SQL Server Integration Services)


Course ID: 3111
Format: Hands-On and Lecture
Duration: 2 days
 
 
  Course Prerequisites:
This course is intended for participants who have some exposure to programming and are interested in a course for designing and developing applications using SQL Server Integration Services (SSIS).
 
Who Should Attend:
This course is intended for programmers, Systems Analysts, and other IT professionals who require an an understanding of how SQL Server Integration Services (SSIS) works.
 
Course Description:
Up And Running With SSIS 2005 (SQL Server Integration Services) is a fast-paced introduction to SSIS 2005. This product is the replacement for the former Data Transformation Services (DTS). The course provides participants with the knowledge and skills necessary to successfully design, develop, deploy, and manage SSIS packages. The participant will learn to use the Extract, Transform and Load (ETL) tool of SSIS.
 
Course Objectives:
At the end of the course, participants will be able to:
  • Describe SSIS 2005 features and functionality.
  • Create an Integration Services package.
  • Implement Control Flow in an Integration Services package.
  • Implement Data Flow in an Integration Services package.
  • Utilize the Package Configuration features available in an Integration Services package.
  • Debug and implement error handling in an Integration Services package.
  • Deploy an Integration Services package.
  • Manage and secure an Integration Services package.
  • Discuss best practices for designing and implementing SSIS solutions.
 
Topics:
  • Introduction to SSIS (SQL Server Integration Services)   
    •  »  The need for Integration Services
    •  »  Business Intelligence in SQL Server 2005
    •  »  Overview of SSIS Packages
    •  »  Using Business Intelligence Development Studio (BIDS)
    •  »  Using Visual Studio to create SSIS packages
  • SSIS Tools and Utilities   
    •  »  SSIS tools
    •  »  SSIS Designer
    •  »  Integration Services Wizards
    •  »  Command prompt utilities
    •  »  Query and expression builder
  • Developing Integration Services Solutions   
    •  »  Creating an Integration Services Solution
    •  »  Using the Import/Export Wizard
    •  »  Using variables
    •  »  Building and running an SSIS Package
  • Designing Control Flows   
    •  »  Overview of tasks
    •  »  Containers and loops
    •  »  Precedence constraints
  • Designing Data Flows   
    •  »  Data Flow Sources
    •  »  Data Flow Transformations
    •  »  Data Flow Destinations
  • Extending SSIS Functionality with Scripting   
    •  »  Introduction to Scripts
    •  »  Syntax
    •  »  Accessing and updating variables
    •  »  Typical functions performed by scripts
  • Extracting Data   
    •  »  Data Sources and Data Source Views
    •  »  Connection Managers
    •  »  Full and incremental data extraction
  • Using the Logging Feature   
    •  »  Setup Logging
    •  »  Controlling events that are logged
    •  »  Capturing data from scripts
  • Monitoring Events   
    •  »  Events
    •  »  Using the Event Handler
  • Debugging and Error Handling   
    •  »  Setting breakpoints in Control Flow Tasks
    •  »  Adding data viewers to data streams
    •  »  Implementing Error Handling
    •  »  Using the Notification Features
  • Deploying Packages   
    •  »  Using the Package Configuration feature
    •  »  Options for deploying Packages
    •  »  Scheduling Package execution