Well, your question is quite detailed. Might i still ask another question. When you say you link src to DEST1 it automaps but when you go to DEST2 it does not automap......do you first unlink src and dest1 because you cant' really map one src to two diff dest at the same time....right? I am assuming you are using a multicast transform between your src and te two destinations....right. So assuming you are(because thats the only way you can go about it unless you have two diff dataflow tasks), maybe dest2 table changed. Go to the dest advanced editor and say refresh cols....maybe that works. If not a good way to check will be to seperately map src to dest2 and see if the prob still persists.