I've experienced some odd behavior.

I have a data pump transform with an ActiveX script that refers to fields by their ordinal position (DTSSource(1).Value...). Yesterday the field order REVERSED, and today it's back to normal.

Yesterday:
Field1=Customer balance
Field2=Change date
Field3=Customer Account #

Today:
Field1=Customer Account #
Field2=Change date
Field3=Customer balance

Has anyone else experienced this? Is this a known bug and is there a workaround? I'm not finding anything with the search terms I'm using.

TIA, Jeff

__________________
--
http://www.vic-fontaine.com/
http://www.heidoc.net/

Have you check if you have a lookup in your transformation?

Jaime E. Maccou

I don't have one. The behavior hasn't repeated itself and I'm hoping it was just an anomaly. The frustration was in having to re-script (twice) as DTS arbitrarily re-ordered things.

I've used DTS for ~5 years and never seen this behavior before.

--Jeff