Home Forums SQL Server 2012 SQL 2012 - General sql agent does not provide details of failure message for SSIS Packages RE: sql agent does not provide details of failure message for SSIS Packages

  • Amit

    Typically, detailed output from SSIS packages isn't written to the job history. You could try piping the output to a file or a table, or even into the job history. That's all in the Advanced tab of the Job Step Properties window. If that doesn't provide enough information, you'll need to set up some sort of logging from within the package.

    John