Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 Running Legacy DTS in SQL2008 R2 as SQL Agent Job
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

2 Posts

Posted - 11/21/2012 :  15:49:36  Show Profile  Reply with Quote
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 ..

Starting Member

2 Posts

Posted - 11/21/2012 :  16:07:27  Show Profile  Reply with Quote
The providers being used are MS ODBC for Oracle and MS OLEDB for Oracle.
Go to Top of Page

Very Important crosS Applying yaK Herder

52326 Posts

Posted - 12/02/2012 :  04:04:24  Show Profile  Reply with Quote
how are packages called from job? using dteexec or by directly calling from job?

SQL Server MVP

Go to Top of Page

Starting Member

6 Posts

Posted - 12/11/2012 :  08:48:03  Show Profile  Reply with Quote
Any help would be greatly appreciated.

Edited by - Law2rence on 12/11/2012 08:51:47
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000