SSIS Package Profile move?

Last Post 17 Dec 2012 10:03 AM by dstoltz. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages Not Resolved
New Member
New Member

17 Dec 2012 10:03 AM

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 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!


Acceptable Use Policy