Hi all, Just wondering what you all do with scripting that cannot be done with the standard controls. I am teaching myself C# to apply it to scripting and was just wondering the above. Any replies from you Guru's would be welcome. thanks.

Sometimes, there is work to do and it's not possible with standard controls or not so easy to do. For Ex. filling variables with complex logic

Here are a few Script Task examples (file tasks such as unzipping/file properties): http://microsoft-ssis.blogspot.com/search/label/SCRIPT%20TASK And some Script Component examples (such as regular expressions, looping through columns with reflection, custom sources): http://microsoft-ssis.blogspot.com/search/label/SCRIPT%20COMPONENT Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com

http://www.sqldev.org/sql-server-integration-services/understanding-how-to-use-script-task-component-31191.shtml Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

To be short: everything you can't do with the built-in components/tasks of SSIS but possible with .NET.MCTS, MCITP - Please mark posts as answered where appropriate.

Loads of stuff. use anything in the .net framework e.g. Regular Expressions. Try reading Don Farmer's book on the subject for ideas: http://bookmooch.com/detail/1932577254 A tip though - don't arbitrarily learn to use a component before you know that you need it. Once you have a use in mind you can channel your learning to something specific rather than flailnig around. Just my opinion.http://sqlblog.com/blogs/jamie_thomson/ | @jamiet | About me

Thnaks all - excellent replies. I just marked the last one as Answer.