While copying database I am getting object not found errors. I looked up the
two tables that were cause of the error and they were missing from the
tables, so I deleted all references to them in the database diagram, views
and stored procedure. But still DTS continues to give the same error. Any
pointers??

Many Thanks
Vibs

Couple of things

Are you using the Copy Objects Task?
If you are do you have "include Dependencies" checked?

Can you not use BACKUP and RESTORE? Even if you do not want everything
it might be quicker to do this and remove on the destination what you do
not want.

Are you sure that what you are erroring on is what you are erroring on?


Allan

"vibs" <vibs (AT) discussions (DOT) microsoft.com> wrote

I take off the include dependencies check and I can't do backup and restore
as I am combining three different databases into one. The error I am getting
is "Invalid object" and the error lists the two tables that do not exist.

Thanks!!!
Vibs

"Allan Mitchell" wrote:

I do dislike this task <grin>

OK So what is the copy objects task tryng to apply to your destination
when the error occurs.


Do you drop and recreate every night?

Could you not just script things out manually once, apply on the
destination and then build DTS packages to move the data?


Allan

"vibs" <vibs (AT) discussions (DOT) microsoft.com> wrote