posted on Tuesday, January 18, 2005 7:24 AM by Knight_Reign

Chatty script components...

For what it's worth...

Integration services has a script transform that may be used as a source or destination adapter or a transform and a script task for work flow tasks.
Both are feature rich and at times a bit too chatty. For example, if I have some invalid code like this:
Invalid code

Running the package I'll get a dialog box that will look something like this:
Invalid code dialog

This dialog will pop up for each error in the script. In most cases this is OK, but at times you don't necessarily want dialogs popping up, say for example if you're working on a demo or in a different part of the package that's unrelated to the script task.

There are a few options for you to eliminate these dialogs.

  • If you click on the "Stop Compiler" button, no more message dialogs will display. The "Continue Reporting" button will, of course, continue to report errors as the compiler finds them.
  • You can disable the task altogether by right clicking on the task you wish to disable and selecting “Disable“ from the context menu. This is very useful for package development and debugging.
  • You can disable the dialogs using a little known setting in the Package Property Pages dialog. Right click on the Project in the Solution Explorer. Select properties. In the “Debugging“ tab, there is a setting called InteractiveMode. Set that to false, and no script component dialogs will show up.
So long as the task is enabled and executes, you will still get warning and error feedback in the output window. You can open that window by selecting View from the main menu and selecting Other Windows and then Output. The output window will look something like this:
Output window 

These are a few ways to better control the debugging environment. Give them a try and let me know what you think. As usual, your (non-spam) feedback is much appreciated. :)

Thanks,

Universe.Earth.Software.Microsoft.SQLServer.IS.KirkHaselden



Comments