How to set ERRORLEVEL in SSIS?

I have a batch file that runs an SSIS job. I have no knowledge of how the SSIS job runs, I took over a project involving it.

The batch file uses %ERRORLEVEL% to detect errors that occur within the SSIS job. It must be expanded to report other errors too.

How do I set the ERRORLEVEL in SSIS?

This question and answers originated from www.stackoverflow.com
Question by (4/10/2009 3:06:51 PM)

Answer

This doesn't appear to be possible. Based on the MSDN documentation, dtexec can only return error codes from 0-6. If you need more detailed error trapping, you will need to store and parse the output from dtexec.

Answer by
Find More Answers
Related Topics  ssis  batch-file  batch-processing  errorlevel
Related Questions

  • Windows batch-file errorlevel question

    I've got a batch file that parses a bunch of file names out of a text file and concatenates them into a single strong - it was previously discussed here . However, I don't want the string to contain…

  • Why does makensis.exe return errorlevel 1 even though it worked?

    I have a NSIS script that works. It compiles, the produced installer works fine. And yet, makensis.exe returns 1 instead of 0. This is a real pain because I use it in a continuous integration setup …

  • ERRORLEVEL inside IF

    Just stumbled into a weird thing with %ERRORLEVEL% and wanted to see if anyone knows why and if there's a way to fix it. Essentially, it seems as if commands executed inside if statements don't set …

  • Errorlevel in a For loop (batch windows)

    I have the following windows batch code: for %%i in (iidbms iigcc iigcd dmfacp dmfrcp rmcmd qwerty) do ( tasklist | findstr /i %%i echo %errorlevel% if %errorlevel% == 0 (echo %…

  • TortoiseSVN from the command line and "IF ERRORLEVEL"?

    I have a batch file I'm running from a Windows XP w/service pack 3 workstation which applies SQL changes to a database using sqlcmd.exe in SQL 2005. I've got a command-line entry for TortoiseSVN …

  • Batch ERRORLEVEL results different from CMD?

    Why does ERRORLEVEL behave differently in these two circumstances? From the command line: Microsoft Windows XP [Version 5.1.2600] (C) Copyright 1985-2001 Microsoft Corp. C:\>aescrypt.exe -…

  • WMCI - how to get the ERRORLEVEL

    I want to use the "wmic" command for finding out if a specific java process is still up and running. E.g.> wmic process where "commandLine like '%ACTMonitor%' and executablePath like '%PATH1%' an…

  • How To Set Errorlevel On Exit of MFC App

    I have an MFC legacy app that I help to maintain. I'm not quite sure how to identify the version of MFC and I don't think it would make a difference anyway. The app can take some parameters on t…

  • Robocopy, Multi-Line Execute Process SSIS Task, or Output Batch File Results to SSIS

    I need to robocopy files from one location to another in a SSIS package. Since the folder is on another domain, I need to impersonate another account before I run the robocopy.exe command. I found I…

  • What is the easiest way to reset ERRORLEVEL to zero?

    I have a post-build event that runs some commands for a c# project. The last command would sometimes cause the ERRORLEVEL value not equils to zero and then the build fails. I want to append an ex…