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 |
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
 Posted - 2006-08-02 : 03:58:57
|
| Hi i've got a batch file .bat and i would like to run this from my DTS package, but i have a feeling when i schedule the job it does not work. Am using the "Execute process task" and then pointing to my .bat file. Would anyone know why this does not work when scheduled, it work fine when i run it my self, am working on a local pc and do not have access to the server, i am also using SQL2000. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-08-02 : 04:49:28
|
| Where is the .bat file?When you run it in the designer the path is relative to your pc and will use your account.When you schedule it the path is relative to the server and it will probably run under the sql server service account.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
Posted - 2006-08-02 : 05:29:07
|
| Yes i was thinking this was the problem as i mentioned that i did not have access to the server.Where is the .bat file? Its on a Network Drive...So i will need to put the batch file on to the server and then it should work ?? |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-08-02 : 05:34:07
|
| If the sql server service has permission on the network share then it should work.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
Posted - 2006-08-02 : 06:19:29
|
| I moved the batch files over to a share on the Network that is shared by the SQL Server, and it worked. when i manually run it so i know the connection works but i will have to wait till tomorrow till i know the schedule job works.. |
|
|
|
|
|
|
Batch Job not working