I have a DTS package in which I am trying to open an Excel
application and dumping data from database. When I execute
the DTS package by itself it runs without a problem. But
when I am calling this DTS package using a Stored
Procedure and I get the Following error "ActiveX component
can't create object: 'Excel.Application'" . The detail
error is below. I would really appreciate if anyone could
help me on this Problem


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
DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1
DTSRun: Package execution complete.

My guess is that you are testing the package on your machine running through
EM. This means DTS executes on your machine which has Excel installed. If
using sp_OA or anything else through T-SQL or a scheduled job it runs on the
server, so make sure you have installed Excel on the server.


--
Darren Green
http://www.sqldts.com

"Sree" <sree.rajamani (AT) cosawebtech (DOT) com> wrote

My questions i most people won't install Excel
on there database servers .
is there a way we can put excel dll and
register it instead of instaling the whole excel thing.

I do not believe there is such a thing as an Excel runtime unfortunately.

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"Samir PAndit" <samirpandit (AT) yahoo (DOT) com> wrote