Post reply

Problem importing from excel via DTS

  • February 20, 2007 at 4:28 pm

    #69518

    I created a DTS package on a sql 2000 server that imports data from an excel file to a SQL table.  There is an ActiveX task that first opens, saves and closes the excel file in order to have it updated via a link to another excel file.  The package runs fine when I launch it from Enterprise Manager on my machine.  However the job I created to run the package fails with the message below:

    Executed as user: xxxx. ...ng...   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 11         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 11         Error source:  Microsoft Data Transformation Services (DTS) Package      Help file:  sqldts80.hlp      Help context:  4500      DTSRun OnFinish:  DTSStep_DTSActiveScriptTask_1   DTSRun:  Package execution complete.  Process Exit Code 1.  The step failed.

    Has anyone seen this before? I would appreciate any thoughts...

  • February 20, 2007 at 8:29 pm

    #690800

    1. The package runs fine when I launch it from Enterprise Manager on my machine.
    2. However the job I created to run the package fails.

    This is because when you run the DTS package from Enterprise Manager on my machine, execution happens on your machine. Your PC has Excel or MS Office installed. But when the job runs, execution happens on the target server which has not Excel or MS Office installed.

    To see what I am saying is correct go to your server and open an Excel file there see if you can open the Excel file.

  • February 23, 2007 at 7:31 am

    #691386

    Thanks for your reply! Does this mean Excel installation needs to be run on the server? My network admin would have a heart attack!!!

  • February 27, 2007 at 10:43 am

    #692120

    Yes, execl needs to be installed on the server.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply