sql server dts: How to Debug SSIS Script Component -- sql server dts

How to Debug SSIS Script Component

Chase
10/10/2006 9:25:02 AM

sql server dts:

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,

Re: How to Debug SSIS Script Component

Darren Green
10/10/2006 11:07:19 PM

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

[quoted text, click to view]