Post reply

sql agent does not provide details of failure message for SSIS Packages

  • July 20, 2016 at 10:19 am

    #328020

    Hi All,

    I am quite new to SSIS, recently i have updated some SSIS packages and changed protection level from "EncryptSensitiveWithID" to "EncryptSensitiveWithPassword" so that i don't need a proxy account to execute my package but i could execute my package from sql agent service account that is achieved but then if my job fails i don't see the detailed failure message in sql job log.

    thanks in advance.

    --Amit

  • July 20, 2016 at 10:28 am

    #1891111

    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

Viewing 2 posts - 1 through 1 (of 1 total)

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