Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

SSIS - Transfer Objects Task - object does not exist

2 views
Skip to first unread message

Michael Tissington

unread,
Nov 11, 2005, 2:11:33 PM11/11/05
to
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 Tissington

unread,
Nov 15, 2005, 12:30:14 PM11/15/05
to

Ches Weldishofer

unread,
Nov 21, 2005, 1:59:45 PM11/21/05
to
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.

0 new messages