We had a pretty bad situation - everytime I would log onto the SQL 2008 server (I'm a domain admin) I'd be OK for a few minutes, and then it would blue screen. This started happening out of the blue (pun intended), with no Windows updates or changes...this also happens if I RDP to it with this profile.
We quickly realized other profiles/users were fine...so I could log on with a domain service account I use for other things, and it would not crash.
So the plan became to remove the old profile, recreate it, and hope for the best...
HERE'S THE PROBLEM: I've copied the SSIS packages from the old profile location to the new profile. SSIS will open the project file, but when I try to open the package, I get errors "Failed to decrypt protected XML node DTS:Password Key not valid for use in specified state"
Is there a way (if so how) I can open these packages while logged on as a different user than who created them???
Any advice REALLY appreciated!