Create Destination Table

DTS Designer

DTS Designer Help

Create Destination Table

Use this dialog box to write your own SQL CREATE TABLE statement for the destination table or to customize the existing destination table. By default, Data Transformation Services (DTS) Designer displays a CREATE TABLE statement for the selected source table. You can edit the table name or any column definitions; however, use care because the new table is created immediately in the destination database.