MS SQLServer DTS Package Transfers Data To Oracle DB And Intermittently Hangs (Doc ID 578044.1)

Last updated on JULY 05, 2017

Applies to:

Oracle Provider for OLE DB - Version: 10.2.0.2.21 to 11.1.0.7.0
Microsoft Windows (32-bit)

Symptoms

A Data Transformation Services (DTS) package may raise exceptions or stop responding (hang) when you run it as a SQL Server Agent scheduled job if the package is using third-party drivers (Oracle) or Dynamic Link Libraries (DLLs) that do not support free threading.

You can use DLLs in a custom task, an ActiveX Script task, or a Transform Data task. The packages may run successfully from Enterprise Manager or they may not experience errors upon each scheduled run; however, if the package never completes, and dtsrun is still running in Task Manager, the package has stopped responding.  You may also see this behavior when you run the dtsrun command prompt utility.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms