SSIS transfer sql objects: table does not exist

#1

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

#2

Abe,

Have you been able to find any solution to this?

-Mabuti

"Abe" wrote:

Quote:

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SSIS transfer sql objects: table does not exist

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

SSIS transfer sql objects: table does not exist - 02-27-2006 , 03:24 PM

RE: SSIS transfer sql objects: table does not exist - 05-12-2006 , 10:16 AM