Phil Thanks for your suggestion,I really like it and prefer it too, but still I have to develop a script for this, as this is assigned to me.

Is it so diificult to build a custom task...

@Raunak

My requirement:

requirement is to build a custom destination adapter, to map a particular tables column that is used again and again in my packages....

The task should accept a connection manager and just map columns of the table required...

The initial requirement is this but can extend in future by adding certain transformation codes to it...as its repeated steps in all the packages..

hope its clear..

I did find some detination adapters in this link but not sure where to look for the sample code...

pasting the link as its very useful one http://ssisctc.codeplex.com/