I'm getting an error that I don't undertsand.

I have created a package with a single task to transfer objects from a SQL
2000 to a SQL 2005 database.

I set CopyAllTables to False and then select a table from the list (so the
designer can see the tables)

However when I run the package, I get an error saying that the table does
not exist.

Any ideas please?

--
Michael Tissington
http://www.oaklodge.com
http://www.tabtag.com

I'm getting an error that I don't undertsand.

I have created a package with a single task to transfer objects from a SQL
2000 to a SQL 2005 database.

I set CopyAllTables to False and then select a table from the list (so the
designer can see the tables)

However when I run the package, I get an error saying that the table does
not exist.

Any ideas please?

--
Michael Tissington
http://www.oaklodge.com
http://www.tabtag.com

Michael did you ever resolve this issue? I've got the same one.

Have tried both SQL logins and Windows Authent on both ends, but to no
avail. Even though I can choose the table I want moved over, when I go
to run I get the table doesn't exist.

This seems like a permissions issue, however the both login's I'm
trying are dbo owner in source and destinatly databases both.

Moving with SQL 2k's copy db task works fine with any of the logins.