Package won't execute as sql job

  • Make sure to select the option "32-bit runtime" on the job step.
    Job Step -> Configuration Tab -> Advanced Tab

  • Just tried. It was a no go. 

    Another note. In the task manager...the executable is open and the XLSM is open as well. I have to manuallly stop the job and both of those processes.

  • Are you logging your package errors? Sounds like you need to do that to track down the error.
    If the XLSM file is open and the other program then you know it makes it to <the whatever you ended up using to go to the PDF> . You said you did this a few ways so it's hard to say but that's one of the ways things can behave when waiting for user interaction or an answer to some prompt. Just one of a ton of possibilities. 

    Sue

Viewing 3 posts - 1 through 4 (of 4 total)

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