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 |
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
 Posted - 2011-07-06 : 10:50:36
|
| Hi,In dataflow, I am using a grid as a dataviewer to view the data as it is flowing...In control flow, there are execute sql tasks which execute sql queries.How can I see the data that flows from one execute sql task to another?Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-07-06 : 13:45:55
|
| you cant see them from within SSIS package as execution of SP happens outside data flow engine. You need to check details of tables affected separately outside package to see effect of SP.However if you've some return values or output variables from SP you can check them in SSIS by putting a breakpoint in post execute of execute sql task and then checking the variable value in locals window------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2011-07-07 : 04:06:40
|
| Thanks |
|
|
|
|
|
|
debug