September 10, 2004 at 9:20 am
I am having problems running any activeX tasks via DTS packages on a Sql Server 7 on NT4.
The startup acount for both SQL service and Agent is the server administrator (both on NT and SQL).
The error I get is
DTSRun: Loading...
DTSRun: Executing...
DTSRun OnStart: DTSStep_DTSActiveScriptTask_1
DTSRun OnError: DTSStep_DTSActiveScriptTask_1, Error = -2147220479 (80040401)
Error string: Invalid Task Result value.
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts.hlp
Help context: 1100
Error Detail Records:
Error: -2147220479 (80040401); Provider Error: 0 (0)
Error string: Invalid Task Result value.
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts.hlp
Help context: 1100
DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1
DTSRun: Package execution complete.
The actual code being run is
Function Main()
Main = DTSTaskExecResult_Success
End Function
This is being run as a activex DTS task.
Note: It does run fine if I run from my PC, but not when its scheduled.
Anyone with any ideas would help, otherwise I will have to ask for the server to be rebuilt as I've tried alsorts.
Thanks
September 10, 2004 at 9:28 am
There may a difference between the versions of DTS running on your server and your PC.
September 10, 2004 at 9:37 am
Yes, but I've logged on directly to the server as the system administrator, then on to EM and created a new activeX task tried executing it, but does not work.
I've also tried reregistering the DTS and activex DLL's and re-installed Internet explorer.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply