Well I am absolutely stumped on this one. I have a DTS package that
transfers some specific tables from one database to another on the same
server. It was working fine a few weeks ago and then one day it started
failing. I have pulled the package apart and run bits and pieces until I
tracked it down to the Transfer Objects Task. The package runs fine when I
manually run the package but when it is put in the scheduler it fails with
the following error. Does anyone have any idea why this might be happening?
My network/LAN folks claim no knowledge on updates that have affected SQL
Server. I'm running SQL Server 2000 on Windows Server 2003.

Executed as user: reserves\arpc_sqlsvc. ...:
DTSStep_DTSTransferObjectsTask_1 DTSRun OnProgress:
DTSStep_DTSTransferObjectsTask_1; Scripting objects for Transfer;
PercentComplete = 0; ProgressCount = 0 DTSRun OnError:
DTSStep_DTSTransferObjectsTask_1, Error = -2147221504 (80040000) Error
string: Invalid OLEVERB structure Error source: Microsoft Data
Transformation Services (DTS) Package Help file: sqldts80.hlp Help
context: 1100 Error Detail Records: Error: -2147221504
(80040000); Provider Error: 0 (0) Error string: Invalid OLEVERB
structure Error source: Microsoft Data Transformation Services (DTS)
Package Help file: sqldts80.hlp Help context: 1100 Error:
-2147221504 (80040000); Provider Error: 0 (0) Error string: Invalid
OLEVERB structure Error source: Microsoft Data Transformation
Services (DTS) Package Help file: sqldts80.hlp Help context: 5700
... Process Exit Code 1. The step failed.

--
Zip