Scheduled Job with Excel fails

Discussion in 'microsoft.public.sqlserver.dts' started by Gary892, Jun 16, 2010.

  1. Gary892

    Gary892 Guest

    Greetings everyone,
    I am having a very strange problem with SQL 2000 DTS.
    I am creating a series of Excel files, “.xls extension†based on an Excel
    Template.
    The DTS starts off with an Execute SQL Task where I query a table for the
    status of 1.
    I then pass parameters into an active script where I put together a file name
    based on the ID of the company. So the Excel file will look something like
    this, S123456.xls
    I created the template and created the worksheet in the template called
    Suppliers. I connect this to my server connection and use a transform to
    populate the file.
    When I have the DTS package open in design mode, I click the run button and
    everything works.
    I save and close the DTS designer and then right click on the package from
    Enterprise Manager and everything works correctly.
    I right clicked on the package and selected schedule and set up a time to run
    the package.
    When I right click the job I get this error:
    Executed as user: Administrator. ...g... DTSRun OnStart:
    DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1
    DTSRun OnStart: DTSStep_DTSExecuteSQLTask_2 DTSRun OnFinish:
    DTSStep_DTSExecuteSQLTask_2 DTSRun OnStart: DTSStep_DTSActiveScriptTask_1
    DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1 DTSRun OnStart:
    DTSStep_DTSDataPumpTask_1 DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -
    2147217865 (80040E37) Error string: The Microsoft Jet database engine could
    not find the object 'Suppliers'. Make sure the object exists and that you
    spell its name and the path name correctly. Error source: Microsoft JET
    Database Engine Help file: Help context: 5003011 Error Detail Records: Error:
    -2147217865 (80040E37); Provider Error: -543884569 (DF94FAE7) Error string:
    The Microsoft Jet database engine could not find the object 'Suppliers'. Make
    sure the object exists and that you spell its name and the path nam. The step
    failed.

    The SQL Agent is configured to use the local administrator account, as you
    can see. I did this to see if the problem is a permission problem. All files
    are on the local server.

    The error says it can’t find the Object Suppliers. This is the name of the
    worksheet in the template and I have confirmed it is in the template.

    If anyone has a solution I would really appreciate it.

    Thanks

    Gary
     
    Gary892, Jun 16, 2010
    #1
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.