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_DTSActiveScriptTas k_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
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_DTSActiveScriptTas
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I recommend splitting the points between all contributors.
Anthony
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
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
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.