Re: Executeable using DTS

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Darren Green (darren.green_at_reply-to-newsgroup-sqldts.com)
Date: 02/24/04 

Date: Tue, 24 Feb 2004 19:12:15 +0000

In message <071b01c3fae5$56f99d80$a301280a@phx.gbl>, Mike
<anonymous@discussions.microsoft.com> writes
>I'm using an execute task to call the system stored
>procedure to execute an exe. Unfortunately, it gives an
>erro saying somethign about SELECT, UPDATE, DELETE etc...
>How should one execute an executeable using DTS, in an
>EXECUTE TASK or something else. Thanks.
>
>Mike

I would use the Execute Process Task to execute an EXE.

If you really want to do this through T-SQL and the Execute SQL Task,
perhaps for security or location contexts, then use some SQL with
xp_cmdshell, e.g.

EXEC master.dbo.xp_cmdshell 'C:\MyApp.exe'

If this is what you are doing and it doesn't work, then please post the
full error message. 

-- 
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com
PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Relevant Pages

  • Unable to execute CGI app
    ... retrieves POSTed data and inserts it into a SQL Server table. ... Since CGI EXE and ISAPI DLL are intrinsically executable by IIS, ... No need to configure anything else to execute a CGI on the server. ...
    (microsoft.public.inetserver.iis)
  • Executeable using DTS
    ... I thought of creating a separate DTS ... hangs when I try to execute it using an Execute task, ... Can I call another DTS routine from a DTS ... >I'm using an execute task to call the system stored ...
    (microsoft.public.sqlserver.dts)
  • Executeable using DTS
    ... I'm using an execute task to call the system stored ... procedure to execute an exe. ... erro saying somethign about SELECT, UPDATE, DELETE etc... ...
    (microsoft.public.sqlserver.dts)
  • Executeable using DTS
    ... >I'm using an execute task to call the system stored ... >procedure to execute an exe. ... >erro saying somethign about SELECT, UPDATE, DELETE ...
    (microsoft.public.sqlserver.dts)
  • Re: Execute Persmission denied on object sp_OACreate
    ... > SQL Server is creating a job behind the scenes. ... > permissions. ... > SA account password and gaining access to the database. ... >>> How can get a user permissions to execute these stored procedures ...
    (microsoft.public.sqlserver.security)