Link to home
Start Free TrialLog in
Avatar of NigelRocks
NigelRocks

asked on

SSIS Error

Anyone know what to make of the error messages I'm getting shown in the attached file?
Image.bmp
Avatar of PedroCGD
PedroCGD
Flag of Portugal image

You are using a column that does not exist before some component. Maybe because you deleted some components... attach a screenshot of dataflow
regards,
pedro
Avatar of DBAduck - Ben Miller
This error is telling you that somehow the XML of the package was modified with a wrong value and now the validation fails.  It wants new Metadata or in other words, it wants to have a refresh of the inputs so that the lineage ID that is kept can be resolved.

You can either delete that part of the data flow and recreate it or try to refresh the metadata.
Avatar of NigelRocks
NigelRocks

ASKER

How do I refresh the metadata?
As dbadluck wrote:
"You can either delete that part of the data flow and recreate it or try to refresh the metadata"
As I wrote:
How do I refresh the metadata?
 
ASKER CERTIFIED SOLUTION
Avatar of DBAduck - Ben Miller
DBAduck - Ben Miller
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial