"Bob" <bhamling@yahoo.com> wrote in message
news:nmt_a.59$o55.14329@news.uswest.net...
> 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.