Scripting Patterns - SQL Server Integration Services Design Patterns - page 109

• Inspecting environmental data, such as available disk space, the status
of Windows services, and so on
Because it's not designed for manipulating data, there is no need to define input or
output metadata, which makes the script task relatively easy to configure. As shown in
Figure 3-5 , there are just a few required configuration elements for this task: specify
the programming language you want to use, choose the variables you want to make vis-
ible within the script, and you're ready to write code!
Figure 3-5 . Script Task Editor
Note For both the Script task and the Script component, the decision to use either C#
or VB.NET should be considered permanent. Once you've selected a language and
opened the script editor, the language selector is disabled. This behavior is by design;
although both languages compile to the same intermediate language (MSIL) code, it
would be difficult for any tool to convert source code from one language to another. The
default language for both tools is C#, so those who prefer VB.NET will have to change
the ScriptLanguage property.