DTS does not exlude non-selected tables -- sql server dts

JP
4/13/2005 4:20:09 PM

I'm trying to use DTS to build test databases. I'm attempting to copy my
production data with the exception of one very large transaction table.

Using enterprose manager I build a DTS package that uses the copy object
task. In the copy specification I uncheck "copy all objects" then use the
select objects dialog to select all objects except the large transaction
table.

When I execute the package it still copies the unselected table. Anyone have
an idea on why this would happen.

I'm running Sql Server 2000 with Sp3.

TIA, JP

Allan Mitchell
4/14/2005 6:36:47 AM

In the task make sure you uncheck "Include dependent objects"

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com

[quoted text, click to view]

sql server dts : DTS does not exlude non-selected tables