Hi All,

I have a datapump which transfers records from CSV file into a Table(same
scenario:-)).I just wondered if before inserting the row in the destination
,I can copy the eigth field in the row which is being tranfered from source
into a global variable.this process should happen for every row.

**CSV File**
**Table**
Record 1 (From source)
Record1(Iin Destination)
D_Field1 D_Feild2 D_Field3



Thanks for your help,

Ray

And do with it what?

The value in the GV will be overwritten on each row




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

I'd like to keep the value of one of the fields in each row in that global
variable to use when logging an error per record.it must be before the first
firld of the record is pumped ,because there might be a validation error in
the first field and I need that global variable reffering to the ID field of
that record to use it in my logger component to log it into another Table.

Why there is no order for the fields in each record.I thought that fields
are pumped from left to right.I put some message boxes in each field script
and I realized that there is no special order from fields in each record.

Thanks for your help
"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote