Summary


The Script Task is a powerful tool for performing simple work that is not supported in stock tasks. The Script Task designer is rich with time-saving features and supporting infrastructure. Even though the Script Task is designed to support short, problem-focused scripts, it can be used to tackle more complex problems, such as building or editing packages, parsing files, or downloading files from Internet servers. Also, remember to take a little extra time to comment the code and use exception handling. These and the other best practices mentioned in this chapter will drastically increase the manageability of the script down the road. The samples show how to do some basic work using the Script Task. Although you can perform more complex tasks, this is about the level of work most people perform with the Script Task. If it gets much more complicated than the most complex of these samples, you might want to start thinking about writing a custom task or writing a class library that you reference from the Script Task.



Microsoft SQL Server 2005 Integration Services
Microsoft SQL Server 2005 Integration Services
ISBN: 0672327813
EAN: 2147483647
Year: 2006
Pages: 200
Authors: Kirk Haselden

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net