Re: Is that OK to run a windows application using a DTS task?

From: Allan Mitchell (allan_at_no-spam.sqldts.com)
Date: 07/08/04 

Date: Thu, 8 Jul 2004 07:41:04 +0100

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@hotmail.com> wrote in message
news:e6ttTPLZEHA.2500@TK2MSFTNGP09.phx.gbl...
> > In article <eeVP7qJZEHA.716@TK2MSFTNGP11.phx.gbl>, Yelson Hwo wrote:
> > > 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?
> > >
> >
> > 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
> >
> Thank you, Allan Mitchell.
> 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.
>
>

Relevant Pages

  • Re: Execute Persmission denied on object sp_OACreate
    ... > I logged in as that user, tried to execute the DTS ... which then launches the DTS package using the sp_OA* procs? ... account is used during proc execution. ... > proxy account to use in the Job Systems tab of SQL Server Agent ...
    (microsoft.public.sqlserver.security)
  • Re: Audit of sql server
    ... The DTS database transfer makes sense now. ... >> SQL Server will not check on this for you. ... >> Compiles each query but does not execute it. ...
    (microsoft.public.sqlserver.programming)
  • Re: delete some user from the public role
    ... really my problem is related with a DTS execution. ... and when I try to execute the DTS from the ... I don't like to take out this 'denied' to the public role, ... > Jasper Smith (SQL Server MVP) ...
    (microsoft.public.sqlserver.security)
  • Re: Audit of sql server
    ... So I'm forced to using DTS. ... > SQL Server will not check on this for you. ... > that you coudl SET NOEXEC on and then try to execute your stored ... > Compiles each query but does not execute it. ...
    (microsoft.public.sqlserver.programming)
  • Re: SQL 2000 - Connection Error with DTS Packages
    ... After I changed all SQL Server 'Database Connection' steps in each of my DTS ... Package" option when you right click a DTS package name in ME. ...
    (microsoft.public.sqlserver.dts)