February 9, 2007 at 5:55 am
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\SharedDrive\ExcelFile.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!
February 9, 2007 at 10:25 am
Does the account that runs SQL Server Agent have access? The package will be run in the security context of that account and it must be a domain account to access a remote location.
Greg
Greg
July 31, 2007 at 12:59 am
July 31, 2007 at 8:46 am
Try logging on to the database server using that account and try executing the package manually.
Greg
Greg
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply