Home Forums SQL Server 2005 SQL Server 2005 Integration Services Execute Process Task - The process exit code was "2" while the expected was "0" RE: Execute Process Task - The process exit code was "2" while the expected was "0"

  • October 19, 2015 at 1:55 pm

    #1834194

    Hello all,

    I'm having a similar issue but the exit code is "12" while the expected was "0". I'm completely stuck and not sure what it means or where it's coming from. Basically it's a container. Inside of it there's and Execute Process Task Editor, which executes a batch file, which has code that pulls data from TERADATA, then exports it to a text file. After this, a Data Flow Task imports the data from the text file into a SQL table.

    The container errors out about 3 seconds after the executable batch has fired off. I looked it up on the web but nothing with "exit code 12.

    Has anyone experienced this situation before, if so, what can be done?

    Regards,

    J.