MS SQLServer DTS Package Transfers Data To Oracle DB And Intermittently Hangs
Last updated on JULY 05, 2017
Applies to:Oracle Provider for OLE DB - Version: 10.2.0.2.21 to 22.214.171.124.0
Microsoft Windows (32-bit)
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms