I have scoured experts exchange and all the other posts related to the failed validation and returned validation status "VS_NEEDSNEWMETADATA" error in Visual Studio 2019 and nothing I found applies to me.
I have an SSIS project that has two SSIS packages in them. Both use the same ODBC connection. Both are querying smiliar views from the same database. These views aren't changing (aka: the columns in the view are, and have been, static).
One of the packages executes fine. The other gives me the VS_NEEDNEWMETADATA error.
I've tired everything suggested in other posts to no avail. I've even completely deleted the Data Flow task and recreated it.
This is not an issue with OLE DB, but I don't want to use OLE DB.
Is there anything else I can try?
I did see in another post that this was only happening to them on VS2019 and not 2017. Does anyone have any info on that?