How can DTS handle data from multiple sources?

• A. By using a single connection object
• B. By using multiple connection objects within a single DTS package
• C. By merging data sources before importing
• D. By creating separate DTS packages for each source

Answer: (B)

DTS, or Data Transformation Services, effectively handles data from multiple sources by utilizing multiple connection objects within a single DTS package. This approach allows for the simultaneous connection to various data sources, such as SQL databases, Excel sheets, and flat files, thereby enabling complex data integration processes.

By employing multiple connection objects, a DTS package can pull in data from each source independently and then transform or manipulate that data as required within the same workflow. This efficient design facilitates easier management of data from diverse environments, reduces complexity, and helps maintain a coherent data processing pipeline.

The other options, such as relying on a single connection object or merging data sources prior to importing, may not account for the distinct characteristics of different data sources. Similarly, creating separate DTS packages for each data source can lead to unnecessary redundancy and increase management overhead, making option B the most effective method for handling multiple data sources in DTS.