Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
1sabine8
Posting Yak Master
130 Posts |
 Posted - 2010-05-17 : 06:32:04
|
| Hi,I have a SSIS 2008 package with a Execute SQL component having a SQL statement as Direct Input. This statement uses input parameters passed. I need to debug this step and watch the variables. How can i do that with the breakpoints?Thanks in advance |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-05-17 : 12:41:02
|
| just right click on the execute sql task and add breakpoint for preexecute and post execute events. on executing package it stops before and after execution of this task. then choose debug->windows-> locals from top menu and you will be able to see value for all variables------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
Debug a Execute SQL Step