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
2,204 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

Question has a verified solution.

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

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

739 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