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
[quoted text, click to view] "vibs" <vibs@discussions.microsoft.com> wrote in message
news:vibs@discussions.microsoft.com:
> 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:
>
> > 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@discussions.microsoft.com> wrote in message
> > news:vibs@discussions.microsoft.com:
> >
> > > 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
> >
> >
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
[quoted text, click to view] "Allan Mitchell" wrote:
> 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@discussions.microsoft.com> wrote in message
> news:vibs@discussions.microsoft.com:
>
> > 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
>
Don't see what you're looking for? Try a search.
