DTS Package Execution (From Job)

[ssrirao]

Hi,
We have DTS package which imports data from an Excel file into an SQL Server 2000 table. The DTS package runs fine when exectued from SQL Server Enterprise Manager, but when we run the Package from a Job it executes when the excel file is in the local drive. The execution of the package fails when the excel file resides on a different Computer shared drive.
We get the following error message.

\\CompName\Shar edDrive\ExcelFi le.xls is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.
Error source: Microsoft JET Database Engine
Help file:
Help context: 5003044

Note that we have access to the shared drive.
Please reply if have faced the same problem!

[iburyak]

Is it possible that the job owner doesn't have rights to remote computer and when package runs within its context it can't access a file?

It is only a guess.

Good Luck.

[ssrirao]

Do u mean the "file access" ?
We have the file access! The file was created and modifed by us in the remote system. Do u think of any IIS problem? As of now there is no IIS installed in these systems.

Regards,
Srinidhi S. Rao