Hi, I want to execute a windows application inside the SQL Server by
defining a task, and but that application will jump a user interface waiting
for user echo, Is that all right?

In article <eeVP7qJZEHA.716 (AT) TK2MSFTNGP11 (DOT) phx.gbl>, Yelson Hwo wrote:
Whilst you can, I probably would not. It will preclude it running as a
scheduled job and the point of DTS is in its name.


Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

I try running a task in which only a step of "cmdexec" job defined , to
execute a windows application which have a user interface awaitting user
reponse. but I am sorry to see there is no interface jumping out to say
hello while the task monitor indicates that the task is running. and in the
windows task manager I find a process of that application. So, here is the
question: what has hindered that application from jumping out its user
interface? and the solution?
Thanks a lot.

I just buily a .Net winform app which displays a form and executed that
through DTS (interactively) and the form came up. Could it be your form is
up but simply behind other windows?

IMHO this is not necessarily the right way to do things though. You should
really grab the information fromt he user prior to firing the package not
during.

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Yelson Hwo" <hy5005 (AT) hotmail (DOT) com> wrote

I check it carefully, find no form came out at all.
As you may know, I am just curious to make sure that a interactive job can
be done in SQL DTS, that's all.
Thanks you.