Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kmjeter
Starting Member
2 Posts |
 Posted - 2012-11-21 : 15:49:36
|
| Hey everyone --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.Any help would be greatly appreciated.Thanks ..Ken |
|
|
kmjeter
Starting Member
2 Posts |
Posted - 2012-11-21 : 16:07:27
|
| The providers being used are MS ODBC for Oracle and MS OLEDB for Oracle. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-12-02 : 04:04:24
|
| how are packages called from job? using dteexec or by directly calling from job?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
Law2rence
Starting Member
6 Posts |
Posted - 2012-12-11 : 08:48:03
|
Any help would be greatly appreciated.    |
|
|
|
|
|
|
Running Legacy DTS in SQL2008 R2 as SQL Agent Job