dbTalk Databases Forums  

Re: SSIS: How do I drag varibale to Watch Window?

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Re: SSIS: How do I drag varibale to Watch Window? in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: SSIS: How do I drag varibale to Watch Window? - 12-08-2006 , 02:30 PM






Hello riga,


So here are the steps I usually follow

Hit a breakpoint in your package
Open the variables window
open a watch window.
Highlight the variable (1 click)
How drag and drop the variable icon onto the watch window.





Regards

Allan Mitchell
Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com

Quote:
How do I drag varibale to Watch Window?
I have only objects in my SSIS Designer.
There is no code.
I selected Variables window and
tried to drag it from there but it didn't work.
Anybody knows how to do it?
Robert




Reply With Quote
  #2  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: SSIS: How do I drag varibale to Watch Window? - 12-08-2006 , 06:16 PM






Hello riga,

Ok So what are you trying to debug? the only thing you will debug is script
in the Script task. On What event are you "Breaking"? A use for wathcing
the variables might be to break on each iteration of a loop which is looping
over files. You can watch the value of the variable change as the breakpoint
is hit on the next iteration.



Regards

Allan Mitchell
Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com

Quote:
Thanks Allan,
It helped.
I see the variables in Watch 1 window.
But F10 diesn't work.
How to debug?
I set a BreakPoint at "AppID task
and it's stuck there.
It's not moving anywhere.
Any suggestions?
Thanks,
Rob
"Allan Mitchell" wrote:

Hello riga,

So here are the steps I usually follow

Hit a breakpoint in your package
Open the variables window
open a watch window.
Highlight the variable (1 click)
How drag and drop the variable icon onto the watch window.
Regards

Allan Mitchell
Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com
How do I drag varibale to Watch Window?
I have only objects in my SSIS Designer.
There is no code.
I selected Variables window and
tried to drag it from there but it didn't work.
Anybody knows how to do it?
Robert



Reply With Quote
  #3  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: SSIS: How do I drag varibale to Watch Window? - 12-11-2006 , 02:50 PM



Hello riga,

Correct that is not the case. You can hit breakpoints on tasks themselves
and within the Script task (code lines). Within the Script task i.e. a break
on a piece of code then you can step into the code quite happily. Breakpoints
on the tasks themselves serve to halt execution and wait for you to let them
go again.


Regards

Allan Mitchell
Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com

Quote:
It's more of a general debugging question now.
It looks like I don't understand how to debug SSIS.
I assumed you can set a breakpoint on a Task
and then move using F10 futher.
As in VB. Is it not the case in SSIS?
Thanks,
Robert
over files. You can watch the value of the variable change as the
breakpoint is hit on the next iteration.

Regards

Allan Mitchell
Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com
Thanks Allan,
It helped.
I see the variables in Watch 1 window.
But F10 diesn't work.
How to debug?
I set a BreakPoint at "AppID task
and it's stuck there.
It's not moving anywhere.
Any suggestions?
Thanks,
Rob
"Allan Mitchell" wrote:
Hello riga,

So here are the steps I usually follow

Hit a breakpoint in your package
Open the variables window
open a watch window.
Highlight the variable (1 click)
How drag and drop the variable icon onto the watch window.
Regards
Allan Mitchell
Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com
How do I drag varibale to Watch Window?
I have only objects in my SSIS Designer.
There is no code.
I selected Variables window and
tried to drag it from there but it didn't work.
Anybody knows how to do it?
Robert



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.