Chapter 6

SQL Server Data Services

Review Questions

1. When does the transformation process usually occur?

The transformation process usually occurs during the migration process, although some transformation may occur during the scrubbing process, while the data is in an intermediate database.

2. What is the main purpose of DTS?

To move and transform data from one or more heterogeneous sources to a destination or multiple destinations

3. What are the source and destination types for DTS?

OLE DB data sources, ODBC data sources, and text files

4. How does OLE DB make data available to any program?

OLE DB providers make data available by exposing standard COM interfaces that any programming language environment with COM support can use.