Post reply

How to get execution response from DTEXEC command line?

  • June 20, 2014 at 6:03 am

    #290208

    Hi all,

    I'm looking to run the SSIS package using DTEXEC command line. I would need to get the execution response and send it to a series of jobs to execute.

    If success -> execute next job

    If fails -> terminate

    How can i get the command line execution response. Currently am using the below command.

    dtexec /FILE "D:\SSISpackage.dtsx" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING EWCDI >D:\ExecutionLog.txt

    I got the response DTSER_FAILURE (1) or DTSER_SUCCESS (0) in the log file "ExecutionLog.txt".

    But how can i get this response as a direct output of the above command?

    Is there any ways to do that? or Should i search through the file and look for the reponse string? Please advice.

    Thanks for your help in advance.

  • June 20, 2014 at 8:48 am

    #1723627

    shafirmubarak (6/20/2014)

    dtexec /FILE "D:\SSISpackage.dtsx" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING EWCDI >D:\ExecutionLog.txt.

    Are you running that command in a command prompt window or are you using it in a SQL Agent job of type 'Operating System (CmdExec)'? If the latter, then simply set the 'On Success Action' and 'On Failure Action' properties to go to the relevant steps in the job. If the former, I guess you'd have to parse the file that you are writing to, as you suggested.

    Regards

    Lempster

  • June 20, 2014 at 9:45 am

    #1723643

    thanks for your response. I appreciate that.

    I am using the batch file not the SQL agent. The batch file will be executed using an ESP job, so i have to send the response to ESP job.

  • June 20, 2014 at 5:51 pm

    #1723724

    shafirmubarak (6/20/2014)

    thanks for your response. I appreciate that.

    I am using the batch file not the SQL agent. The batch file will be executed using an ESP job, so i have to send the response to ESP job.

    Since I don't have ESP... what is ESP? (Pardon the pun. :-D)

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply