Save password as MD5

A friend of my self asked me how he can save a password not as clear text. He wanted to encrypt the password and save the encrypted string in the database.

How can he do this. I heard from somebody that he might do this with SSIS. Unfortunately I doesn't understand what he ment. Maybe somebody can help me here.

Regards Markus

I'm also not sure what password he means, and what exactly he wants to encrypt? By the way, MD5 is not encryption algorithm, it is "message digest" (secure hash) algorithm.

If you have bigger picture, we could try to suggest how SSIS or new SQL Server features may help.

SQL Server 2005 has extensive support for encryption and hashing inside the database, you may consult at
http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=92&SiteID=1