batch file in scheduled SSIS job 1

[luzippu]

Hi
I'm using a job to run a batch file with several robocopy commands in it.
The step in the scheduled job runs a SSIS package saved in the Server Package Store.
The SSIS package uses an 'Execute Process Task' control flow item.
The 'Execute Process task' simply calls and execute the batch file. (WindowStyle property = Maximized)
The package/job runs fine in both Visual Studio and in Management Studio. However when run from the latter (SQL Management Studio Job) the command prompt window (dos screen) doesn't open so I can't tell at what stage the batch file is in at any given time.

ie: i have several 'if exist...(echo ...)' in the batch file to output on the screen specific messages.
If I run the SSIS from Visual Studio, the package runs and the 'dos window' dispays.
If I run the SSIS from within a Job, the package still runs in the background, but the 'dos window' does not display.

How can I get the window to open when running the package from a job?

Thank you

 

[mrdenny]

You don't. Jobs run in the backround and not on the server's console. They can't display data to the console.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[Catadmin]

Change your batch output from a screen to a text file. That way, if the job bombs, you can see exactly at what point it quit when you access the text file later.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"