[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 993
  • Last Modified:

Transfer SQL Server Objects Task: error-- cannot be found at the datasource

the above task works fine for several 2005 to 2005 DBs, but when i tried it on one set today, i get the error

"[Transfer SQL Server Objects Task] Error: Execution failed with the following error: "ERROR : errorCode=-1071636475 description=Column "Psap_OldRec" cannot be found at the datasource.  helpFile=dtsmsg.rll helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}".

I confirmed with sys.columns that both databases has Psap_OldRec in the table and the table have the same number of columns etc.

what could be wrong? is there any other system table/view to check to confirm/isolate?

thanks
0
anushahanna
Asked:
anushahanna
1 Solution
 
elimesikaCommented:
Since this is really a column not found error , I suggest that you compare source and target databases with this free tool
http://www.starinix.com/sqlcompare02.htm
0
 
anushahannaAuthor Commented:
thanks!
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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