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
The Data Viewers will halt the pipeline ad infinitum so be careful. It may
> 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)
>
> "Allan Mitchell" wrote:
>
>> 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 >>> 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)
>>>
>>> "Allan Mitchell" wrote:
>>>
>>>> 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 >>>>> 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?
>>>>> Please help. A kitten may die if you do not