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 |
|
cidr
Posting Yak Master
207 Posts |
 Posted - 2011-10-11 : 11:22:58
|
| Hi,I hope someone can help.I've recently created a SSIS package that triggers a bat file, which in turn triggers an EXE file. I've done this with a Execute process task container.If I run the package direct from SSIS, it works. To test this, I used the following command in a bat file:@echo offStart "" "C:\Program Files (x86)\Notepad++\notpad++.exe"This simply opens Notpad++. The package will run the bat file from it's folder location and in turn, notepad will open. However, starting the package from SQL Server agent job will not have any results.I'm unsure why this is; permission problem with the Account or something else?Does anyone know what I may be doing wrong or have to do?Many thanks for any help |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-11 : 13:15:58
|
| is it throwing some error? or job executes and nothing happens?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
cidr
Posting Yak Master
207 Posts |
Posted - 2011-10-12 : 11:53:15
|
| Hi,No error, the package runs but the batfile/exe file does notCheers |
|
|
|
|
|
|
SSIS Package > Bat file > Exe file