pbackstrom
Programmer
Just burned a few hours tracking down an overflow error so thought I'd share the results (for anyone doing keyword search in the future).
Was getting overflow errors in my session logs. Debugging using an existing session and stopping on the offending records yielded no clues. Ran in debug mode without discarding data (that is, letting it flow through to the Oracle target), and same thing, everything worked fine.
Turns out my Enable High Precision was not checked in the session. Somehow the debugger must have been enabling it on its own since I was using the same session.
Was getting overflow errors in my session logs. Debugging using an existing session and stopping on the offending records yielded no clues. Ran in debug mode without discarding data (that is, letting it flow through to the Oracle target), and same thing, everything worked fine.
Turns out my Enable High Precision was not checked in the session. Somehow the debugger must have been enabling it on its own since I was using the same session.