Data encryption and Decryption in SQL Server 2008-The CodeGain

In recent past there are many projects around ETL just only Data transfer from the legacy databases. But because of security concerns some of the data needs to encrypted and pushed across the Server. Here I just want to give a brief detail. And just to help the beginners.