I have developed an SSIS package that executes and works on development environment.
When I deploy and executes the package on the MSSQL Server, I get the following errors: failed validation and returned validation status "VS_NEEDSNEWMETADATA"
- I use the same MSSQL 2014 server for both environments.
- I use the same MySQL ODBC connector on both environments.
- The above error is produced on source tables that reside on MySQL database.
- No error occur for MSSQL source tables.
Attached log when executes via deployment: