Link to home
Start Free TrialLog in
Avatar of sjrh
sjrh

asked on

DTS runtime error - can't create object: 'Excel Application'

I've a DTS package that reads data from an Excel spreadsheet before loading into SQL Server
As the spreadsheet data is a series of named cells I use an ActiveX Script Task to load some
global variables.  This involves creating an Excel.Application object.  No problem and running the package from my PC, it works perfectly.

When I fire the package off from a stored procedure (will eventually be a scheduled SQL Agent job), it fails with:

   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'

Do I need Excel or some ADO loading on the database server?  If so, can you give me a pointer as to how I load the ADO?

Thanks


Steve
ASKER CERTIFIED SOLUTION
Avatar of Anthony Perkins
Anthony Perkins
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of CleanupPing
CleanupPing

sjrh:
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
EXPERTS:
Post your closing recommendations!  No comment means you don't care.
I recommend splitting the points between all contributors.

Anthony
No comment has been added to this question in more than 264 days, so it is now classified as abandoned.

I will leave the following recommendation for this question in the Cleanup topic area:
   Accept: acperkins http:#8182542, arbert http:#8182718

Any objections should be posted here in the next 4 days. After that time, the question will be closed.

monosodiumg
EE Cleanup Volunteer