Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
a.g.mohod
Starting Member
6 Posts |
 Posted - 2006-10-10 : 08:29:16
|
| Hi,I am creating a simple DTS package on SQL server installed on my local machin and with sa user which fetches data from excel file on a computer in my LAN (a drive is mapped) and save to a textfile. I have full rights of the folder on that computer. Now when I right click the DTS package and execute it, it gets execute with no problem with proper output file.But my problem begins when I try to shedule the job for running this DTS. The sheduled job fails. In job history the following erro is shown though the file is not opened by any one:Executed as user: MBIHBZ80\SYSTEM. ...ecuting... DTSRun OnStart: Copy Data from Sheet1$ to J:\DT2XLS.txt Step DTSRun OnError: Copy Data from Sheet1$ to J:\DT2XLS.txt Step, Error = -2147467259 (80004005) Error string: The Microsoft Jet database engine cannot open the file 'J:\DTS_Test.xls'. It is already opened exclusively by another user, or you need permission to view its data. Error source: Microsoft JET Database Engine Help file: Help context: 5003051 Error Detail Records: Error: -2147467259 (80004005); Provider Error: -534709256 (E020FBF8) Error string: The Microsoft Jet database engine cannot open the file 'J:\DTS_Test.xls'. It is already opened exclusively by another user, or you need permission to view its data. Error source: Microsoft JET Database Engine Help file: Help context: 5003051 DTSRun OnFinish: Copy Data from Sheet1$ to J:\DT2XLS.txt Step DTSRun: Package execution complete. Process Exit Code 1. The step failed.Can any one help on this? Any suggestions will be greatly helpfull.Amit MohodClover Infotech Pvt Ltd.Mumbai |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2006-10-10 : 08:33:35
|
| http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=73291-------Moo. :) |
 |
|
|
|
|
|
DTS Error