Post reply

SSIS - how to watch the values in SSIS variables in debug mode

  • November 16, 2009 at 11:47 am

    #216805

    I am using an Execute SQL task to run an SP that return a state abbreviate but I can't find out if it did return a value and if so, what, how to watch the values in SSIS variables in debug mode

  • November 16, 2009 at 11:53 am

    #1079845

    Put a break-point on the step, and there's a window at the bottom that'll have the values in it.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • November 16, 2009 at 12:45 pm

    #1079872

    If the variables are not in the window at the bottom, you will need to open that. During package execution, select the Debug menu, select Windows, and then click "Locals."

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • May 12, 2021 at 3:01 pm

    #3882379

    To add variables to watch window,

    1. Add a breakpoint to the next task
    2. Execute package
    3. Once the flow hit the breakpoint, Open Package explorer
    4. Drag and drop variables from the Package Explorer window on to the Watch window

    Done. Start debugging!!

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

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