I am getting the same error message, I have an OLE DB source that gets a set of columns from a variable that executes a given stored proc.

The data flow task can be individually executed successfully, but if I run the job or the package, it is giving me the error "Description: "component "OLE DB Source" (1)" failed validation and returned validation status "VS_NEEDSNEWMETADATA" ".

Any advise is appreciated.

Things I have tried:

1: remove OLE DB source and destinations and re create it.

2. remove the entire data flow task itself and recreate it.