Post reply

SSIS Debugging Execute SQL Task

  • November 3, 2009 at 3:59 pm

    #156370

    I'm trying to debug (actually to see the result set) an Execute SQL Task but not having much luck.

    I set a breakpoint on the task, and right clicked/Execute Task, pulled up the Watch 1 window...but the name is grayed out and I cannot enter anything. There is no option to add.

    What am I doing wrong? Also how can I drag the variables to this window when they are no where to be found?

  • November 7, 2009 at 4:34 pm

    #1076383

    mbokker (11/3/2009)

    I'm trying to debug (actually to see the result set) an Execute SQL Task but not having much luck.

    I set a breakpoint on the task, and right clicked/Execute Task, pulled up the Watch 1 window...but the name is grayed out and I cannot enter anything. There is no option to add.

    What am I doing wrong? Also how can I drag the variables to this window when they are no where to be found?

    You cannot debug Execute SQL Task. If you want to see your result set, follow these steps:

    1. Download and install Trash Destination component.

    2. Insert a data flow task.

    3. In the data flow task, insert OLE DB Source or other appropriate source.

    4. Insert Trash Destination and connect the source to it.

    5. Right-click on the connection between the two components and select Data Viewers. Click 'Add' and then click OK.

    Execute the package and you should now be able to see your result set.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

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

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