I'm somewhat new to SSIS and very new to Oracle so any pointers would be helpful.
We're running SSIS 2008 with Oracle 10g source and destinations (using the Attunity connectors). The SSIS packages run correctly when executed manually and *usually* run on a scheduled basis correctly as well but every several days one of the packages never completes and instead errors out with ORA-03135 (connection lost).
When the package runs correctly it takes about 15 minutes, and on nights it fails it shows as having a duration of over 6 hours culminating in the connection error above.
I haven't seen anything unusual in the alert logs on the Oracle server but I'm not sure if I have all the necessary tracing on - any debugging tips or insight would be greatly appreciated.
View Complete Post