Encryption in SSIS package - symmetric keys

1) We have OLTP DB on 2000 & OLAP DB on 2005.

2) We have decided to use SSIS for migration and interface is BIDS to develop, build, deploy & install SSIS packages.

3) We even have to encrypt some tables colmns data while reading from source so that it is secure in network and gets into target database as such requiring decryption for reports and front end display.

4) For database Security, we are going to use AES 256 Symmetric Encryption. We will be using RSA for Asymmetric Key Encryption, 1024 Bits.
Can you please give links on these 2 encryption mechanisms.

5) Where can we use Symmetric Encryption & Asymmetric Key Encryption i.e on columns of tables i.e. data or password & based on what do we decide which to use?

6) Please post links/code to generate these keys. Where do we fit this code in SSIS package & where do we use the keys. Can you give me code for keys fitted into
following query:
insert into EmpDest
select e.empno, e.ename, d.deptno, d.dname
from emp e, dept d
where e.deptno = d.deptno
go

Thanks in adavnce.

I've created a feature request to load symmetric keys into SSIS. As it is now, I issue a batch SQL statement to encrypt the data outside of SSIS.

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=256770