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.

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 Running Legacy DTS in SQL2008 R2 as SQL Agent Job

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.
Go to Top of Page

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 MVP
http://visakhm.blogspot.com/

Go to Top of Page

Law2rence
Starting Member

6 Posts

Posted - 2012-12-11 : 08:48:03
Any help would be greatly appreciated.



Go to Top of Page
   

- Advertisement -