I have a SSIS package andI am trying to copy tables from SQL 2005 to SQL 2000. The schemas for the tables on both the databases is dbo. However, I get the following message:
[Transfer SQL Server Objects Task] Error: Table "xxxx" does not exist at the source.
I see quite a few posts online about this, but I haven't been able to find a solution yet.