Dynamics In SSIS?

I have a Table say

Table1
Col 1 Col2 Col 3
A X1 1
A X2 2
B Y1 3
C Z1 4
C Z2 5
( Col1 represents Entity names, Col2 represents there respective field name and Col3 represents the values of those field name)

How can i use the above Table1 and update table A, B, C
Ex:
Table A
X1 X2
1 2

Similarly Table B
Y1
3

and Table C
Z1 Z2
4 5


2 Question:
I was trying to use for each loop container. I am getting this error:

Error: Variable "User::ADOVar" does not contain a valid data object
I followed all the steps in the links
http://www.whiteknighttechnology.com/cs/blogs/brian_knight/archive/2006/03/03/126.aspx
and check out other sources but unable to track where the problem is?

Can some body help me out please