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.
Create Destination Table
DTS Designer Help