Hello, Bob!

Do you really need to recreate the tables each time ?
Are you simply pumping data ?

--

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

: We are attempting to create a DTS package to copy tables
: from one server to another on a weekly schedule. Both
: servers are SQL 2000. The problem is when we use the
: wizard within the DTS package designer, the list of source
: tables does not include the table owner and some of the
: tables being transferred exist in the source server
: twice, with the same name but with different owners.
: When we create the task and check only one of the tables,
: it's random which table is actually copied - one time it
: will copy owner1.tablename and without changing the
: package at all the next time it will copy
: owner2.tablename. Short of creating the package with VB,
: does anyone know a workaround for this? Thanks in
: advance.
--- Microsoft CDO for Windows 2000

Hi Allan, we wanted to make it dynamic enough to adapt to
changes in the the source tables' structure.