hi opc.three,

Sorry for the delay in sending message.

yes you are correct they both resides in the same database and simple proc which holds all the transactions will be fine. but i have orders to do it ssis. that's why i'm doing it.