all groups > sql server dts > april 2007 >
You're in the

sql server dts

group:

breakpoints - Unable to step. Not implemented


breakpoints - Unable to step. Not implemented adolf garlic
4/27/2007 12:58:02 AM
sql server dts:
Number of articles on web showing how to implement breakpoints in SSIS
=zillions

Number of articles on web showing how to 'step into'
=bugger all

Am I being a bit thick?

I'm used to hitting F11 to move on in VS.net

It hits the breakpoint but then what?

Either I can carry on running the whole thing or, er, that's it

Is my paradigm correctly configured?
Have I dovetailed my 'conflab' correctly?

Re: breakpoints - Unable to step. Not implemented Allan Mitchell
4/30/2007 7:48:50 PM
Hello adolf,

On what have you hit a breakpoint? A Task or a line of code in a Script
Task. The former is "Unsteppable" the latter is "Steppable".


--

Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com

[quoted text, click to view]

Re: breakpoints - Unable to step. Not implemented adolf garlic
5/1/2007 2:01:01 AM
It is a task.

Is this something that will be implemented in the future?

I can't understand why you would want to set a breakpoint if you can't do
anything when it is hit. i.e. examine the data retrieved by a stored proc, or
see the params being passed in. (at least there doesn't appear to be anything
in watch/local which is where I am used to looking)

[quoted text, click to view]
Re: breakpoints - Unable to step. Not implemented Allan Mitchell
5/1/2007 4:25:57 PM
Hello adolf,

You use the breakpoints on tasks (Events) to watch variables (Either type
into the watch window the variable User::vName or drag from the variables
window)

--

Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com

[quoted text, click to view]

Re: breakpoints - Unable to step. Not implemented adolf garlic
5/4/2007 7:48:00 AM
I found what I needed.

Double clicking the arrows between tasks allow you to add a data viewer.

The process always stops when it hits this and allows you to view the data
(in a grid or other form)



[quoted text, click to view]
Re: breakpoints - Unable to step. Not implemented Allan Mitchell
5/5/2007 12:00:00 AM
Hello adolf,

Glad you found what you needed. Just a little terminology to help. In the
Data Flow the components are not referred to as Tasks. They are either Source
Adapters, Destination Adapters or Transformations. Also the green and red
lines between these components are called Paths.

The Data Viewers will halt the pipeline ad infinitum so be careful. It may
also cause back pressure on the source system and hold locks that it would
previously have released.

--

Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com

[quoted text, click to view]

AddThis Social Bookmark Button