SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
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
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

kmjeter
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 ..
Ken

kmjeter
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

visakh16
Very Important crosS Applying yaK Herder

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

Go to Top of Page

Law2rence
Starting Member

USA
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  
 New 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.03 seconds. Powered By: Snitz Forums 2000