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 2000 Forums  SQL Server Administration (2000)  DTS job failed

Author  Topic  mlei50 Starting Member 1 Post Posted - 2001-08-07 : 15:53:07 Hello, can anyone help me on this, thanks. i use DTS wizard to create a DTS package to import data from oracle 7.3 database into SQL server v7.0. Before doing this, i have installed oracle client ODBC driver (version2.5.3.1.0B) and sqlnet (2.3.4.0.0). The package just run fine. But when i try to execute the job in job window, it failed and with the following error message: ... 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: 160 (A0) Error string: Specified driver could not be loaded due to system error 126 (Oracle73 ... Process Exit Code 1. The step failed. I have checked PATH which is ok. it includes oracle BIN directory. Thanks in advance.