Thanks for reply, I am using ID for Business Key.

Thank you all of you guys.

I am sorry john to confuse to, that was typo mistake, In last post i asked i only need those fields who don't have null value if there is two...

Phil Thanks for your reply,

This is the requirement and company follow this requirement from last 14 years, Let me post some sample data may be it gives you ...

Thanks for your lesson !

Thanks for your reply,

Approach 2: Design package using FEL->ST->DFT/EST

*I am sorry i don't understand what FEL,ST, DFT, AND EST stand for*

Could you plz provide me code for "incremental load"...