Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
DTS Failure when scheduled as Job (2nd try)
jcrr, kjobob, My particular problem with running a package that contained a .bat file, and the .bat file not executing, was caused from using wordpad.exe instead of notepad.exe to edit the .bat file. Once I copied the contents of the file to my clipboard from the wordpad file and into the...- robox
- Post #12
- Forum: Microsoft SQL Server: Programming
-
DTS Failure when scheduled as Job (2nd try)
Tom, In my situation, the account used to administer SQL is a valid NT account. The account has been given administrator privledges. The file system that contains the .bat file is completely shared. The .bat file contains two DOS commands, a copy and a del. Neither command executes...- robox
- Post #6
- Forum: Microsoft SQL Server: Programming
-
DTS Failure when scheduled as Job (2nd try)
Hi. Unfortunately, I don't have the answer, but a related problem. I was wondering since some time has passed, whether you have resolved this issue. I believe the answer has to do with converting the DOS commands to a win32 executable file.- robox
- Post #2
- Forum: Microsoft SQL Server: Programming
