Script Component As Source: The Value Is Too Large To Fit In The Column Data Area Of The Buffer.

In my quest to get the Script Component as Source to work, I've come upon an error that says "The value is too large to fit in the column data area of the buffer.". Of course, I went through the futile attempt to get debugging to work. After struggling and more searching, I found that I need to run Dts.Events.FireProgress to debug in a Script Component. However, despite the fact that the script says:





Code Block
Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper
Imports Microsoft.SqlServer.Dts.Runtime.Wrapper
Imports Microsoft.SqlServer.Dts.Runtime

...

Dts.Events.FireProgress..






I get a new error saying: Error 30451: Name 'Dts' is not declared. Its like I am using the wrong namespace, but all documentation indicates that Microsoft.SqlServer.Dts.Pipeline.Wrapper is the correct namespace. I understand that I can use System.Windows.Form.MessageBox.Show, but iterating through 100 items makes this too cumbersome. Any idea what I may be missing now?

Thanks,

John T