August 8, 2012 at 1:24 pm
First, I apologize if there is something out there already as I have been unable to find it.
Does anyone have a script that would allow me to pass in my password for my encrypted packages in the msdb datastore and be able to view the actual xml? My company initially thought it was a good idea to decrypt the packages, but as time has gone on there really isn't any sensitive data saved in these. What we would like is to be able to decrypt the XML and then be able to search it for key items (This particular part I already have done). I have not been successful though in decrypting the packages.
Any assistance would be greatly appreciated.
Thanks
August 9, 2012 at 12:14 am
You can decrypt packages using dtutil, but this is is done when loading the package, so you'll need to copy it to some other place.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 9, 2012 at 6:31 am
So you are suggesting using dtutil and say copy function to place a decrypted version in another folder?
August 9, 2012 at 6:35 am
Something like that yes. Not ideal, but the only thing I can think of right now.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 9, 2012 at 6:37 am
Ok, thanks for the assist.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply