Created a DTS package and trying to run it from remote machine. It has the
client tools already loaded. Have the same problem from another database
server. Will run locally but not from another machine. The appropriate dlls
are in the sql install folders.
The initial step is an ActiveXcomponent and this is where it's failing.
Any suggestions.
thanks,


C:\>dtsrun /S servername /E /N packagename
DTSRun: Loading...
DTSRun: Executing...
DTSRun OnStart: DTSStep_DTSActiveScriptTask_1
DTSRun OnError: DTSStep_DTSActiveScriptTask_1, Error = -2147220482 (800403FE)
Error string: Error Code: 0
Error Source= Microsoft VBScript runtime error
Error Description: ActiveX component can't create object:
'wtDtsPackage.SubsetIm
port'

Error on Line 8

Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 1100

Error Detail Records:

Error: -2147220482 (800403FE); Provider Error: 0 (0)
Error string: Error Code: 0
Error Source= Microsoft VBScript runtime error
Error Description: ActiveX component can't create object:
'wtDtsPackage.SubsetIm
port'

Error on Line 8

Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 1100

DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1
DTSRun: Package execution complete.

cheilig,

Did you register the component/dll?

Ilya

"cheilig" <cheilig (AT) discussions (DOT) microsoft.com> wrote

Ilya,
Have registered dtsffile.dll, dtspkg.dll, dtspump.dll, and axscphst.dll. All
registered succesfully. The associated .rll are all in place.

"Ilya Margolin" wrote: