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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-08-06 : 00:35:18
|
| Mike writes "i am utilizing DTS package to transfer data from oracle database to sql server and odbc driver is Microsoft ODBC for Oracle.after DTS package is created, manual execution is no problem. It just goes through fine.But if i schedule it as a job it fails with error message showing in a dialog box titled as Microsoft ODBC for Oracle:"The Oracle(tm) client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3 (or greater) client software installation.You will be unable to use this driver until these components have been installed."When i looked into job history log and got the following error message:DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: Delete from Table [PCard].[dbo].[EMP_INFO_GLOBAL] Step DTSRun OnFinish: Delete from Table [PCard].[dbo].[EMP_INFO_GLOBAL] Step DTSRun OnStart: Copy Data from SNAP$_EMP_INFO_GLOBAL to [PCard].[dbo].[EMP_INFO_GLOBAL] Step DTSRun OnError: Copy Data from SNAP$_EMP_INFO_GLOBAL to [PCard].[dbo].[EMP_INFO_GLOBAL] Step, Error = -2147008507 (80074005) Error string: Unspecified error Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts.hlp Help context: 1100 Error Detail Records: Error: -2147008507 (80074005); Provider Error: 0 (0) Error string: Unspecified error Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts.hlp Help context: 1100 Error: -2147467259 (80004005); Provider Error: 0 (0) Error string: [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV fai. The step failed.Thanks for help." |
|
|
|
|
|
DTS