DTS runtime error - can't create object: 'Excel Application'
Posted on 2003-03-21
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?