dbms:mssql:edu:maintain_sql2005:module6
Lesson 1: Overview of Data Transfer
What Is Data Transfer?
Extract from the source
Transform the data
Load to the destination
Data transformation involves:
Lesson 2: Introduction to SQL Server Integration Services
What Is SSIS?
How SSIS Processes Tasks
Control flow
Containers
Tasks
Precedence constraints
Data flow
Sources
Transformations
Destinations
Wizards
SSIS Designer
Command-prompt utilities
Lesson 3: Using SQL Server Integration Services
What Are Data Sources and Data Source Views?
Data sources
Data source views
Types of data sources
What Is a Connection Manager?
What Is Package Control Flow?
Tasks
Precedence constraints
Containers
What Is a Data Flow Task?
Source
Transformation
Destination
How to Deploy Packages
Lesson 4: Features of SQL Server Integration Services
SSIS Tasks
Data tasks
Database object transfer tasks
File and network protocol tasks
Script and program execution tasks
WMI tasks
Maintenance plan tasks
Data format transformations
Sorting and grouping transformations
Column transformations
Lookup transformations
Custom processing transformations
Split, merge, and join transformations
Audit transformations
SSIS Events
SSIS Logging
dbms/mssql/edu/maintain_sql2005/module6.txt · 마지막으로 수정됨: 2008/05/22 15:08 저자 gauryan