Solved

I receive the following errors when I run a SSIS package. Any assistance or information would be greatly appreciated.

Posted on 2014-09-30
2
1,721 Views
Last Modified: 2016-02-11
Warning: The external columns for LegalEntity are out of synchronization with the data source columns.

The column “BusinessRegistry” needs to be added to the external columns.
The column “BusinessRegistryNumber” needs to be added to the external columns.
The column “ExpiryDate” needs to be added to the external columns.
The column “ExpiryReason” needs to be added to the external columns.
The column “MaintenanceState” needs to be added to the external columns.
The column “NextMaintenanceDate” needs to be added to the external columns.
The column “TransferTo” needs to be added to the external columns.

The LegalEntity Inputs[OLE DB Destination Input] ExternalColumns[NextCertificationdate] needs to be removed from the external columns.
The LegalEntity Inputs[OLE DB Destination Input] External Columns[CertificationState] needs to be removed from the external columns.
Error “LegalEntity” failed validation and returned validation status “VS_NEEDSNEWMETADATA”
0
Comment
Question by:tesla764
2 Comments
 
LVL 65

Accepted Solution

by:
Jim Horn earned 500 total points
ID: 40352667
In your data flow...
   Refresh the source task
   Delete the precedence constraints (aka green arrows) between source and destination
   Then re-connect them.
SSIS is notorious for a data flow needing to be re-mapped.
0
 

Author Closing Comment

by:tesla764
ID: 40352909
Thanks
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

In couple weeks ago, I encountered an extremely difficult problem while deploying 2008 SSIS packages to a new environment (SQL Server 2014 standard).  My scenario is: We have one C# application that is calling 2008R2 SSIS packages to load text fi…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now