Post reply

SSIS console.writeline not working consistently

  • February 29, 2016 at 2:39 pm

    #325201

    All:

    Have 2 packages with nearly identical c# first script components. Both running in agent context using

    same ssis proxy account. Both work find in non-debug via VS Desktop, but only one works properly

    via agent. I use the system.comsole.writeline to output parameter settings. The package that works

    correctly logs to agent, the other does not.

    Any ideas where to look for discrepancies ? I've tried both package & component properties (identical).

    Thanks

  • February 29, 2016 at 2:46 pm

    #1861981

    Are you using the project deployment model?

    If so, you could try looking on the All Executions report. The run-time values of all params would be logged there.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • February 29, 2016 at 2:49 pm

    #1861983

    Nope, older package deployment, right now we have no reason to use the package deployment...

    Thanks

  • February 29, 2016 at 2:53 pm

    #1861986

    Also, since I'm deploying to MSDB, are the "All Executions" reports available ?

  • February 29, 2016 at 3:02 pm

    #1861988

    rsampson (2/29/2016)

    Also, since I'm deploying to MSDB, are the "All Executions" reports available ?

    No. And there's a reason right there 🙂 Logging is taken care of for you if you use project deployment.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • March 1, 2016 at 7:10 am

    #1862089

    So, back to the original question, one console writes to the agent log correctly, one does not, same

    methodology to do the output...

    Looking for clues...

    Thanks

  • March 18, 2016 at 6:52 am

    #1866123

    Found the issue. the agent has this little checkbox "Include step output in history", cured the problem...

Viewing 7 posts - 1 through 6 (of 6 total)

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