This one is hard to explain but I will try.

I have a DTS process that calls another DTS process (using the ActiveX
script object). Within the called DTS process I have a code loop that breaks
once a numeric comparison fails.

e.g. if (MyCurrentNumber < TheMaxNumber) then "continue the loop" else
"break out of the loop"

My problem is this. When I run the DTS process within the IDE the logic
works.

However when I attempt to run the DTS from the calling DTS the logic fails.

In other words MyCurrentNumber = 2004 which is greater than TheMaxNumber =
2003 yet the comparison fails and the code continues to loop and eventually
errors out during the process.

Has anyone had a similar experience? What did you do to resolve it?