having 2 fields always in a variable before going through each record in a datapump -- sql server dts

RayAll
4/6/2005 1:48:07 PM

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

RayAll
4/6/2005 1:53:27 PM

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
[quoted text, click to view]

sql server dts : having 2 fields always in a variable before going through each record in a datapump