In Designer, where you saw the transformation for "select", there are additional tabs for "insert", "update" and "delete". Use that area to define your transformation that converts the data to right format.
Ramesh, I saw those tabs, but since we have lots of attributes mapped, is there anyway we don't need to write INSERT sql from scratch, because most of attributes mapping can refer to SELECT mapping, only one or two need specail treatment.
Also, if I write, how to write the INSERT sql which can be generic enough to take care of all case of INSERT, such as all columns insert, partial columns insert with different combination.
Do you have any examples I can learn?