I have the following error message
"tep_DTSExecuteSQLTask_2 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_2
DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish:
DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: DTSStep_DTSDataPumpTask_2
DTSRun OnError: DTSStep_DTSDataPumpTask_2, Error = -2147213242 (80042046)
Error string: ActiveX Scripting Transform 'DTSTransformation__21' was not
able to initialize the script execution engine. Error source: Microsoft
Data Transformation Services (DTS) Data Pump Help file: sqldts80.hlp
Help context: 30631 Error Detail Records: Error: -2147213242
(80042046); Provider Error: 0 (0) Error string: ActiveX Scripting
Transform 'DTSTransformation__21' was not able to initialize the script
execution engine. Error source: Microsoft Data Transformation Services
(DTS) Data Pump Help file: sqldts80.hlp Help context: 30631
DTSRun OnFinish: DTSStep_DTSD... Process Exit Code 1. The step failed."

The user that runs this job does not have admin rights to the server...
If I use a server admin then the job runs fine...
I want to be able to use to use the non-admin user...please advise...

After more reading into what this patch fixes...I have come across Article:
825042
http://support.microsoft.com/kb/825042/...
that this patch was supposed to fix...but it created it on the server after
the upgrade to SP4...

OS: Windows 2000 Advanced Server (SP4)

"Khone" wrote: