Hi Rick,

Thanks for your reply...

I would like it to insert like (as in first scenario you mentioned)

1 1 ...

Hi Rick,

My Source table structure is like this:

ID (Primary Key) , MGR_Id , MGR_NAME , MGR_DOJ

Values are :

11XXX ...