enforcing business rules while transferring

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I have a CSV file which I'm trnsferring its content to a table with
follwoing feilds:

1)ClientID
2)EmailAddress
3)AddressDescription
4)Primary

there could be multiple address for each client ,but each client **MUST**
have atleast one address with "Primary" flag set to "Y" (which mean that one
is his Primary address) and also one of the addresses **Must** also contain
an EmailAddress.Right now I am using a datapump task to pump data from CSV
into the Table.How and where can I enforce this business Ruls?

Thanks a lot



.

Relevant Pages