I have been working on a SSIS package. Package is extracting data from Access Databases , excel sheets and SQL server databases and loading into SQL Server database.
Its been working fine but all of a sudden it has started throwing an error, Its not a run-time error, but whenever I open the solution in Visual Studio, the takes a couple of minutes to validate all the package components (which is expected because the package is huge) at the end of the validation it throws the following error:
I have searched online and it appears that some other people has also encountered the same issue but no one seems to have suggested a proven method to fix it.
I have tried registering the dts.dll because some of the posts online suggested this should fix the issue but no joy.
Any pointers or suggestion in the right direction are much appreciated. Thanks