dbTalk Databases Forums  

Batch file in DTS

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Batch file in DTS in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
paul
 
Posts: n/a

Default Batch file in DTS - 09-16-2004 , 09:11 AM






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?

Reply With Quote
  #2  
Old   
Andrew J. Kelly
 
Posts: n/a

Default Re: Batch file in DTS - 09-16-2004 , 09:18 AM






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

Quote:
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?



Reply With Quote
  #3  
Old   
 
Posts: n/a

Default Re: Batch file in DTS - 09-16-2004 , 09:31 AM



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?
Quote:
-----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?


.


Reply With Quote
  #4  
Old   
Andrew J. Kelly
 
Posts: n/a

Default Re: Batch file in DTS - 09-16-2004 , 11:24 AM



If the TServices account is not a member of the sa role it will run under
the account of the one you have set uyp for the Proxy. I would check there
first.

--
Andrew J. Kelly SQL MVP


<anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:
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?


.




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.