My SQL 2000 DTS "Copy SQL Server Objects task" is loading tables I've deselected on the SELECT OBJECTS screen
(NOTE: there are no dependencies between the objects I've UNchecked and the remainning objects)
Characteristics of the Task "Copy" tab:
SELECTED: Create destination objects, Drop destination objects first, Include all dependant objects, Include extended properties
SELECTED: Copy data, Replace existing data
SELECTED: Use Collation
BUTTONS:
SELECT OBJECTS: all boxes checked then I de-select 5 LARGE volume tables
OPTIONS: Unchecked all 3 SECURITY Options; Checked all TABLE options
(NOTE: there are no dependencies between the objects I've UNchecked and the remainning objects)
Characteristics of the Task "Copy" tab:
SELECTED: Create destination objects, Drop destination objects first, Include all dependant objects, Include extended properties
SELECTED: Copy data, Replace existing data
SELECTED: Use Collation
BUTTONS:
SELECT OBJECTS: all boxes checked then I de-select 5 LARGE volume tables
OPTIONS: Unchecked all 3 SECURITY Options; Checked all TABLE options