I am trying to transfer tables from a 2000 database to a 2005 database. I selected only the tables I wanted and when executing the task I get:
Error: 0xC002F363 at Copy Tables, Transfer Sql Server Objects Task: Table "XXX" does not exist at the source.
Task failed: Copy Tables
I have the correct permisions on both (they are both dbo.) and I can create DataFlow tasks for each individual table, however there are about 50-75 tables I need to copy. I tried recreating the package with no luck. Any ideas?
Thanks,
Abe
I did not read your post carefully. I was referring to a different bug related to transfer of objects between two SQL Server 2005 servers.
As far as your problem is concerned, it has been identified as a bug and being handled.
Hopefully the fix will be available soon.
No comments:
Post a Comment