Thursday, March 22, 2012

error in transfer sql task

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

Try using "Windows Authentication" instead of "SQL Server Authentication" at the destination. I remember seeing a bug (which has been fixed and will be made available in the next SP release).|||I am using windows authentication in the destiantion. I don't have a choice other than using sql authetication at the source though.|||Sorry. The information I gave was not correct.

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