http://sqlblog.com/blogs/argenis_fernandez/archive/2011/11/09/tale-of-an-encrypted-ssis-package-in-msdb-and-a-lost-password.aspxYesterday a Developer at work asked for a copy of an SSIS package in Production so he could work on it (please, dear Reader – withhold judgment on Source Control – I know!). I logged on to the SSIS instance, and when I went to export the package… Oops.enCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlblog.com/blogs/argenis_fernandez/archive/2011/11/09/tale-of-an-encrypted-ssis-package-in-msdb-and-a-lost-password.aspx#39736Thu, 10 Nov 2011 05:49:39 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:39736Robert L Davis<p>I'm glad I was able to help out! Also glad that you weren't screwed. Disappointed to see that the password is in plain text. You should file a Connect item for it.</p>http://sqlblog.com/blogs/argenis_fernandez/archive/2011/11/09/tale-of-an-encrypted-ssis-package-in-msdb-and-a-lost-password.aspx#39738Thu, 10 Nov 2011 08:58:29 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:39738Greg M Lucas<p>A very usefult tip - but frightening at the same time</p>http://sqlblog.com/blogs/argenis_fernandez/archive/2011/11/09/tale-of-an-encrypted-ssis-package-in-msdb-and-a-lost-password.aspx#39746Thu, 10 Nov 2011 15:13:32 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:39746Stefan K.<p>Very usefull blog post! </p>http://sqlblog.com/blogs/argenis_fernandez/archive/2011/11/09/tale-of-an-encrypted-ssis-package-in-msdb-and-a-lost-password.aspx#39752Thu, 10 Nov 2011 20:26:08 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:39752D. Pendleton<p>Remember, the only true security is physical security...</p>http://sqlblog.com/blogs/argenis_fernandez/archive/2011/11/09/tale-of-an-encrypted-ssis-package-in-msdb-and-a-lost-password.aspx#40967Wed, 11 Jan 2012 22:00:24 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:40967Anup Warrier<p>LOL!!! Excellent post</p>http://sqlblog.com/blogs/argenis_fernandez/archive/2011/11/09/tale-of-an-encrypted-ssis-package-in-msdb-and-a-lost-password.aspx#41024Fri, 13 Jan 2012 16:24:31 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:41024Cybrduck<p>Thanks a million! &nbsp;Our project is saved.</p>http://sqlblog.com/blogs/argenis_fernandez/archive/2011/11/09/tale-of-an-encrypted-ssis-package-in-msdb-and-a-lost-password.aspx#46530Thu, 06 Dec 2012 07:25:50 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:46530Bharath K Mohan<p>Thanx a lot. Excellent work around..</p> http://sqlblog.com/blogs/argenis_fernandez/archive/2011/11/09/tale-of-an-encrypted-ssis-package-in-msdb-and-a-lost-password.aspx#47172Wed, 16 Jan 2013 01:35:51 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:47172Alma<p>You are awesome!!!</p> http://sqlblog.com/blogs/argenis_fernandez/archive/2011/11/09/tale-of-an-encrypted-ssis-package-in-msdb-and-a-lost-password.aspx#48260Fri, 15 Mar 2013 15:00:29 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:48260Joe Koppin<p>Thank you for this, we have been using a 2005 package and every developer has been here less than 2 yrs so we were stuck until we stumbled upon this, thanks a bundle!</p> http://sqlblog.com/blogs/argenis_fernandez/archive/2011/11/09/tale-of-an-encrypted-ssis-package-in-msdb-and-a-lost-password.aspx#48988Tue, 07 May 2013 14:43:49 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:48988Bob<p>You, sir, kick ass!</p>