Our team recently upgraded from SQL 2000 to SQL 2008 R2. We have dozens of legacy DTS packages that we still need to run daily via SQL Agent until they can be re-written using SSIS.
Many of them are Oracle-sourced and these specifically are causing the following issue.
When we msdtc onto the server and run the packages, they execute successfully. When we attempt to run jobs to execute the package, it fails with an "Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation." Oracle Client 11g 32-bit is installed on the SQL Server as our DBA said the 32-bit version was necessary to work with BIDS. SQL Server/SSMS on this machine is 64-bit.
The job steps are cmdexec command lines that use DTSExec to run the packages.
Running Legacy DTS in SQL2008 R2 as SQL Agent Job
Posted - 11/21/2012 : 15:49:36
