SSIS transfer sql objects: table does not exist

I am trying to create a SSIS package that copies a bunch of tables from
a SQL Server 2000 DB to a machine with SQL Server 2005. I can see and
select the tables in the editor, but when the package runs, I get:
Table "XXXXXX" does not exist at the source.

On both sides, the tables are dbo and I have the correct permissions.

Any ideas?

thanks,
abe

Abe,

Have you been able to find any solution to this?

-Mabuti

"Abe" wrote:

> I am trying to create a SSIS package that copies a bunch of tables from
> a SQL Server 2000 DB to a machine with SQL Server 2005. I can see and
> select the tables in the editor, but when the package runs, I get:
> Table "XXXXXX" does not exist at the source.
>
> On both sides, the tables are dbo and I have the correct permissions.
>
> Any ideas?
>
> thanks,
> abe
>
>