• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 203
  • Last Modified:

[Transfer SQL Server Objects Task] Error

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.
0
IUAATech
Asked:
IUAATech
  • 2
  • 2
1 Solution
 
brad2575Commented:
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.
0
 
IUAATechAuthor 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.
0
 
brad2575Commented:
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.
0
 
IUAATechAuthor 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.
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now