I have created a DTS package that calls CreateObject(InternetExplorer.Application).

It opens an asp page which has some code on it (Which runs fine if i just open it manually in a browser window.)

It runs fine when executing in the design area (manually) but when scheduled as a job it fails with the following error

DTSStep_DTSActiveScriptTask_1, Error = -2147220482 (800403FE) Error string: ActiveX Scripting encountered a Run Time Error during the execution of the script.

The owner of the job is sa user and the SQL Server Agent is running under System Account.

Any help would be appreciated as this is driving me insane.