i create dts package that runs console app process.
when i run package manually - all is done ok -
the app's window is created, it executes and closes.

but when i do a job and try to run it the job hangs up,
nothing happens.

?

Does the external App have any UI? If so then this type of application is
unsupported when using the SQL Server Agents scheduler.

--
Darren Green
http://www.sqldts.com

"Alexander Nenashev" <nenashev (AT) hotbox (DOT) ru> wrote

yes, it has. understood, thanx

"Darren Green" <darren.green (AT) reply-to-newsgroup-sqldts (DOT) com> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ
× ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ: news:%23X6jv7fTEHA.2716 (AT) tk2msftngp13 (DOT) phx.gbl...

An application can have a UI as long as user interaction of any kind is not
required. Try 'execute on the main package thread' option on the step that
executes the application.

Ilya

"Darren Green" <darren.green (AT) reply-to-newsgroup-sqldts (DOT) com> wrote

1. Are you passing in any parameters/globals

2. I assume you are using the Job Scheduler to run your package. Are you using a DTSRun command line to make it go? If so, double click the item for your package in the job, and make sure the Type is set to Operating System Command (CmdExec)

3. Any other information you can provide may make it easier to debug for you

Regards
John Miceli, MCDBA