![]() | |
![]() |
| | Thread Tools | Display Modes |
#1
| |||
| |||
|
#2
| |||
| |||
|
|
Im try to run a .bat file using DTS. It works if I execute form within Local Packages, However when I try to schedule it fails with a 'specified file not found'. All the .bat does is rename a file on C:\. Has anyone had this problem before? |
#3
| |||
| |||
|
|
-----Original Message----- Sounds like a permissions issue. It may be a different account depending on if you run the package directly of thru a job. http://www.support.microsoft.com/?id=269074 -- Andrew J. Kelly SQL MVP "paul" <anonymous (AT) discussions (DOT) microsoft.com> wrote in message news:0b1401c49bf7$18993e20$a301280a (AT) phx (DOT) gbl... Im try to run a .bat file using DTS. It works if I execute form within Local Packages, However when I try to schedule it fails with a 'specified file not found'. All the .bat does is rename a file on C:\. Has anyone had this problem before? . |
#4
| |||
| |||
|
|
From what I can I'm using the same account throughtout. How do I check the user accounts and permissions. If SQL Server agent is using and account and im logged in using TServices with the same account would there still be a problem? -----Original Message----- Sounds like a permissions issue. It may be a different account depending on if you run the package directly of thru a job. http://www.support.microsoft.com/?id=269074 -- Andrew J. Kelly SQL MVP "paul" <anonymous (AT) discussions (DOT) microsoft.com> wrote in message news:0b1401c49bf7$18993e20$a301280a (AT) phx (DOT) gbl... Im try to run a .bat file using DTS. It works if I execute form within Local Packages, However when I try to schedule it fails with a 'specified file not found'. All the .bat does is rename a file on C:\. Has anyone had this problem before? . |
![]() |
| Thread Tools | |
| Display Modes | |
| |