You wouldn't typically use DTS to do this. The way I would do it would be;

1.

Script out the whole of the DB using SQLDMO. Create the the other DB.
Reapply the scripts

2.

Copy the DB (BACKUP/RESTORE). Create scripts to remove the data in DRI
order. Backup the database again and use as a template.


You could also use the Transfer Objects Task and select not to take data
with you.

--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

[quoted text, click to view]
to create a new database (dbFoo2) with the tables minus the data, i.e.
structure but no content. Help!