Just a general question.

I'm just getting started designing some Integration Services Packages and am
wondering what's the best way to debug a Script Component in the Data Flow.

Currently I'm just saving all my changes to the script and running the
Package. When I did something wrong in the script, I get an error message
from Visual Studio pointing me to my script. Should I be able to set
breakpoints and view the value of objects in my script just like I could for
any old console application I develop in .NET?

Any suggestions are greatly appreciated!

Thanks,

- Chase

Unfortunately Script Components do not really support debugging, features
such as breakpoints do not work. This a known limitation.

Script Tasks work fine with breakpoints, but components are more painful.

Writing log entries or firing events is perhaps the obvious way to get some
visibility of what is happening at run-time, but do remember to take them
out once you are happy with the code as they can be quite costly, especially
if firing for every row.


--
Darren
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com

"Chase" <Chase (AT) discussions (DOT) microsoft.com> wrote