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 |
|
lw1990
Yak Posting Veteran
85 Posts |
 Posted - 2007-07-03 : 17:32:59
|
| Hello, I setup a DTS package quite simple, just export a view to a text file on another server which will be used by another application. The source is a view in the local SQL Server, the Connection is MS OLE DB Provider for SQL Server, the destination is H:\Apps\application1.txt.After I set up it, I execute it the text file application1.txt was created in the folder Apps. But after I set up the schedule and run the Job, it's failed.The part of error message is:DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147467259 (80004005) Error string: Error opening datafile: The system cannot find the path specified.Can anyone tell me why I execute the DTS that runs ok, and after schedule it, the Job can not find the path and failed to run? Thank you. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-07-03 : 17:38:14
|
| H:\Apps\ needs to be visible to the account that the SQL Server service uses as that's what is used when jobs run. Go to the console of the SQL Server by walking to it, remote desktopping to it, VNC'ing to it, terminal servicing to it, ... Log into the server using the same account that the SQL Server service uses. Open up Windows Explorer, do you see H:\Apps?If the SQL Server service uses the Local System account and H:\Apps is a network resource, then that's your problem.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-04 : 00:07:15
|
| Sql agent service account needs permission on remote file. If job owner is non-sysadmin, need set proxy account. |
|
|
|
lw1990
Yak Posting Veteran
85 Posts |
Posted - 2007-07-05 : 10:01:09
|
| Thank you Tara and R Miao.It works, First of all I reset the File name with a full path \\ServerApp\H\Apps\Application1.txt, not the mapped drive H:\Apps\...Secondly, after I scheduled the DTS, I changed the owner of the Job to ...\Administrator not my login name, even I am an admin.So, thank you for the helps from both of you. |
|
|
|
|
|
|
|
|
DTS is working but not working in scheduled