Hey I have SSIS project deployed in SQL Server SSIS. I also have a scheduled job which runs the deployed SSIS proeject from SQL Server. (See the screenshot) Now when this job runs, (which is basically runnign the dtsx package) I get an error email which says that
Load Fact Staging Table Failed on - Reporting Data Warehouse with following Error Messages:
"Fact Destination" failed validation and returned validation status "VS_NEEDSNEWMETADATA".
I understand that this error can be solved if I open the dtsx package on the server using visual studio, I can fix it by right-click on the data source and then select edit, and then YEs. In my case since this only fails on production server, I do not have access to visual studio. So my question how can I fix this error by just using the dtsx package
Schema Comparison
tool to find the changes and apply them to your development database – Panagiotis Kanavos