When using DTS to export to a relational MR database, why is only one table created instead of several?
When I use DTS to export to a relational MR database, I can see only one table (VDATA) in the DTS wizard. I was expecting to see several tables (Variables, Responses, OtherData, and so on) which will be created in the SQL Server database.
VDATA is the name of the Data Model's flat virtual table and it is the only table shown in the DTS wizard. If you select Relational MR Database CDSC for the destination, the Relational MR Database CDSC will create the Variables, Responses, and OtherData tables in the database.
See also