SQL 2014, VS 2013 Data Tools
Yesterday all of our 100+ SSIS packages were working fine. Today we're getting errors such as this one:
Error 1 Error loading MYSSISPackage.dtsx: Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available.
Why did this start happening all the sudden, and more importantly how do I fix it? I've looked around but the solutions are things such as changing the connection manager from Native SQL to OLEDB. That's not acceptable, since these worked yesterday but not today. I need to know what caused this and how to fix it the correct way w/o a Band-Aid approach.
Thanks in ad