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 |
|
dogli
Starting Member
32 Posts |
 Posted - 2002-09-24 : 19:50:29
|
| Hi ,I am trying to scheduling a DTS package. I can munually run the package without any problem. But the package does not run with schedule. The packge has two steps:1. get connect to a remote Oracle databse2. Import some data to SQL Server 7.0 based on some creteria. I use the Transform Data task directly.Any good ideas?Thanks for all of your help./ Here's error code:=====================================================================DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSDataPumpTask_1 DTSRun OnError: DTSStep_DTSDataPumpTask_1, 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 failed Error source: Microsoft OLE DB Provider for ODBC Drivers Help file: Help context: 0 DTSRun OnFinish: DTSStep_DTSDataPumpTask_1 DTSRun: Package execution complete. Process Exit Code 1. The step failed.====================================================================== |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-09-25 : 05:53:42
|
| Trusted connection?Check the user that the schedule is running thye dts package under.Do you manually run the dts package on the server? If not then maybe the there is no access to the oracle box from the sql server.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
DTS failure