Post reply

Read values of variables in SSIS

  • December 21, 2009 at 9:47 am

    #143694

    How can I read the value of the variables in my SSIS process?

    It execute fine. But I dont see what are the values that the var are taking. i have a foreach loop and some SQL task and I compare var values, but I dont see what is reading.

    any idea?

    Thank you in advance

  • December 21, 2009 at 9:50 am

    #1094892

    Use the debugging components within BIDS to set a breakpoint on the task where you would like to evaluate the variable values. When your package execution reaches the breakpoint, type the variable names into the Watch window and it will display their current values.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • December 21, 2009 at 10:05 am

    #1094903

    I dont know what im doing wrong. But my Watch window doesnt let me to type anything.

    I marked the breakpoint, the package stops there, but i can edit anything in the Watch window.

    any idea?

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

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