Post reply

Dubugging a Foreach loop

  • May 19, 2009 at 5:58 am

    #205053

    Hi -

    Im trying to debug a Foreach loop and Im not sure how - the package is designed to select a set of records from a table , pass that result set to a foreach loop. Values from each row of the result set are selected and passed to a stored proc in the foreach loop(Execute SQL task).

    The package is running successfully but the stored proc isnt being executes.

    Any ideas? If I could just see what values are being passed to the Execute SQL task, I might be able to make headway.

    Thanks

  • May 19, 2009 at 6:32 am

    #996874

    Add a break point on Pre-Execute event of Execute SQL Task and when in debug mode, go to debug window > Locals > Variables to see the values in the variables

    --Ramesh

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

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