We help IT Professionals succeed at work.

[Transfer SQL Server Objects Task] Error

IUAATech
IUAATech asked
on
Medium Priority
216 Views
Last Modified: 2012-05-06
I have a SSIS package andI am trying to copy tables from SQL 2005 to SQL 2000. The schemas for the tables on both the databases is dbo. However, I get the following message:

[Transfer SQL Server Objects Task] Error: Table "xxxx" does not exist at the source.

I see quite a few posts online about this, but I haven't been able to find a solution yet.

Please help.
Comment
Watch Question

Commented:
what is the syntax you are using?  From the error it looks like you are just trying to copy the data only and the not the table structure that is why you are getting that error.

Author

Commented:
There is no syntax since I am using the control flow item "Transfer SQL Server Objects Task". it has a GUI and it lets me copy both the structure and the data or just the data. In my case, I am trying to replae the data in the destination table.
Commented:
if you are trying to replace the data does the table exist?  IT doesnt look like it from the error.  Either that or the permissions on the SSIS package do not have the correct permissions to see that the table exists already.

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

Commented:
Yes, the tables exist on both the source and the destination databases.

I am not sure if the issue is with permission on the SSIS package, but I will check.
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.