As you begin the planning process, familiarize yourself with the structure of your source and target databases. The data translation specification ( DTS) files (*.dts) that you define in Workbench load data from the source to one or more targets.
The source must be a single result set, such as an entire file, the contents of a table, or the result of a SQL query. Each target must be one file or, in the case of a database, one or more tables within one database.
Each source requires a DTS file. However, you can integrate data from the source into multiple target objects.
See also