I have a DTS package that runs fine when executing by itself but when
I try to execute the DTS package from a Stored Procedure I am getting
"ActiveX component can't create object: 'Excel.Application' "
See below for a detail error that I am getting when run from a Stored
Procedure.

Can any one please help me on this issue.
Thank you

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:
'Excel.Application'



Error on Line 7



Error source: Microsoft Data Transformation Services (DTS) Package

Help file: sqldts80.hlp

Help context: 4500



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:
'Excel.Application'



Error on Line 7



Error source: Microsoft Data Transformation Services (DTS) Package

Help file: sqldts80.hlp

Help context: 4500

I think this may be the following bug:

http://support.microsoft.com/default...ort.microsoft-
.com:80/support/kb/articles/q185/1/26.asp&NoWebContent=1



Knowledge Base Article - 185126


--
Posted via http://dbforums.com

I didn't see the original post but make certain that the capitalization is
EXACTLY the same in the SP as in the DTS name.

good luck
tonyo

"GregScot78" <member44437 (AT) dbforums (DOT) com> wrote