locked
creating Dump when error happens in SSIS job RRS feed

  • Question

  • Hi,

    I have modified a SSIS job to create a dump whenever am error happens while running a ssis job. I found that despite this setting when the job fails it does not create a dump in the path specified in the error and usage reporting settings.

    Any clue!!

    Regards

    Rajaniesh 

    Tuesday, May 30, 2017 6:26 PM

All replies

  • Hi Rajaniesh,

    Not sure what you will be looking in the dump for. It does not normally help fixing any issue.

    I think this option works for an admin running the job.

    Not a built in Agent account.

    Lastly, you can open a bug at https://connect.microsoft.com/


    Arthur

    MyBlog


    Twitter

    Tuesday, May 30, 2017 7:21 PM
  • We are using the same account used for admin access on the Sql server still it is not generating the dump. I believe that the dump is the only way to resolve the issue because the job failure happens intermittently.
    Tuesday, May 30, 2017 7:56 PM
  • Microsoft can you reply.
    Wednesday, May 31, 2017 3:58 PM
  • Can Microsoft Team or somebody help here?
    Thursday, June 1, 2017 12:13 AM