having access to a field in source before Datapump transfers the row into the destination -- sql server dts

RayAll
3/6/2005 3:10:14 PM

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)
[quoted text, click to view]
S_Field1 S_Feild2 S_Field3
D_Field1 D_Feild2 D_Field3

Thanks for your help,

Ray

Allan Mitchell
3/7/2005 6:33:08 AM

And do with it what?

The value in the GV will be overwritten on each row

[quoted text, click to view]

RayAll
3/7/2005 9:31:17 AM

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

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server dts

sql server dts : having access to a field in source before Datapump transfers the row into the destination