Multiple choice sql-server

You have been asked to copy a one-table Access database to another table that exists in a SQL Server 7 database. What is the best method you should use to copy the data?

  1. The copy_db command at a command prompt

  2. Data Transformation Services

  3. The oslp utility

  4. Data Transfer System

  5. The BULK INSERT statement

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Data Transformation Services (DTS) is the legacy SQL Server 7.0/2000 tool designed specifically for importing, exporting, and transforming data between different formats, such as moving an Access table into a SQL Server database.