I'm pumping a csv file into a table using datapump .I'd like to do some
validation on every single field on each record while I'm transferring
records and for that reason I need to retrieve a value from database based
on the first two fields in CSV file.I noticed that I don't have access to
data in "Pre source Data function" and I cannot use "On insert success"
too,because it's when acually the record has been transfered.Where should I
do my look up? I know that I can do that lookup in each field ,but I'm
looking for a way to do the lookup on the beginning of the each record
processign and keep the result in a global varaible for instance and use
that global variable in all my validations on each field. Is it doable?

Thanks

I forgot to say that the only chance I have is that the first row of my csv
file is a comment (it's always there) so I might be able to use "On insert
success",but still curious to know if there is a better way of doing that.

Thanks
"RayAll" <RayAll (AT) microsft (DOT) com> wrote