Step Error code: 80040E09

[gvision]

Hi,

I have created a job that runs a dts which imports a table to an Excel Sheet.
But the job fails with the error code : 80040E09; it also mentions that the Excel sheet can only be read.

Could someone help me.

 

[DrewConn]

Are you exporting a sql table into an excel sheet?? Also make sure that the excel file is not in use or open by any users.

 

[gvision]

Yes, I'm exporting a sql table into an excel sheet. I'm also sure that the file is not open by any user because the job runs at midnight...

 

[DrewConn]

I would check a couple of things.
1) Can you run the run by itself(not the scheduler) without any errors?.

2)If the job runs, then try to execute the same job using the scheduler at a time when you can watch the results. Does it error out?

3)If it runs by itself but not from the scheduler you need to make sure that the owner of the DTS job is the same as the owner of the schedule tht is set up to run the package.

Hope this helps.

 

[gvision]

I can't run the job by itself (I mean not from the scheduler). However I can execute the DTS succesfully without running the job.

 

[DrewConn]

You need to make sure the object owner on the DTS package is the same as the owner of the job. Once those are the same you shoudn't have any more problems.

 

[gvision]

I have made sure those are the same but still doesn't work... It's driving me mad...

 

[RickCole]

I think this may still be a permissions problem.

Log onto the physical SQL Server box using the domain account the server is running under. I'm assuming here that your server is not running under the Local system account.

Try editing your excel spreadsheet from here and see if the server has the correct permissions to do so. If not this is where the problem lies. If this is okay run your DTS package from here and see if you still get any error messages.

Rick