How to debug in SSIS and SQL SERVER

I was confused that how to debug in SSIS and SQL SERVER.

Let's talk about SSIS first,It can be divided into 2 parts:The debug of control flow and data flow.

For control flow,we can right click the blank place and select 'Edit Breakpoints' to add a breakpoint,then debug it.

For data flow,turn to data flow page and right click on the arrow and select 'Data Flow Path Editor' and then click on 'data view' and configure it.After finish it,we can see the data change when we debug.

 

For the debug of SQL SERVER,we can refer to :http://wenku.baidu.com/view/4ed255fafab069dc502201b9.html

 

 

 

转载于:https://www.cnblogs.com/answeryou/archive/2012/05/09/2493383.html