Return Code from Execute Process Task

From: Magnus (magnus.hagberg_at_qbranch.se)
Date: 12/15/04 

Date: Wed, 15 Dec 2004 10:45:57 +0100

Hi

I have created a DTS package.
I one of the steps I execute a exe.application that if I want to return a
value if it was successful or not.
In execute process task a can set a return code for success. But what if a
want to return a failure code an continue the dts package?

How do I do this?

/magnus

Relevant Pages

  • Re: DTS and stored procedure
    ... The DTS package can be stored in the Microsoft® SQL ... > Displays the command prompt options. ... > of the command used to execute the DTS package because the server name, ... Specify server_name to ...
    (microsoft.public.sqlserver.dts)
  • Re: DTS vs Job Problem for 2 Digit Date format
    ... When you execute a DTS package it comes to you. ... The job will execute on the server itself. ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ...
    (microsoft.public.sqlserver.dts)
  • Permissions problems loading DTS file in C#
    ... http://SQLDev.Net/DTS/DotNETCookBook.htm to attempt to load a .DTS package ... in C# through the COM Interop services, and execute it. ... Using explicit path references ... Placing the file on a remote network drive ...
    (microsoft.public.sqlserver.dts)
  • How can a non-owner start a job?
    ... There is a DTS package scheduled for execution every night as a SQL Server ... "Execute permissions default to the public role in the msdb database. ... who can execute this procedure and is a member of the sysadmin fixed role ... A user who is not a member of the sysadmin role can use ...
    (microsoft.public.sqlserver.security)
  • DTS export data from Sqlserver to MDB
    ... I setup a DTS package to export a table from sql server to microsoft acess ... Z:\Payment ... I can execute the DTS package from Enterprise Manager but I want to allow my ...
    (microsoft.public.sqlserver.dts)