Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations sizbut on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Copy SQL Server Objects Task Ignoring my Selections

Status
Not open for further replies.

btturner

Programmer
May 17, 2001
175
US
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

 
I removed the COPY DATA check.. and built all my objects - then went back in and "only" preformed a COPY DATA.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top