aaron.reese (2/19/2013)
FWIW I don't like script tasks as I think that they obfuscate what is happening (and VB.net scares me!) . I would prefer to use an alternative where possible, even if it is not so efficient.
Scared I guess I can understand but there is no reason to be 🙂 Obfuscate though? :ermm: Moreso than using an Execute SQL Task that pushes a result into a Variable?
Personally I prefer C# but VB.net can get the job done too. Unfortanately C# is not an option for you until you move to SSIS 2008 or above. I can see your concern about learning a new language but know that Script Tasks will help you bridge the gap between what SSIS provides out of the box and what you will actually need to produce for solutions using SSIS as the requirements get more complex. I would just say to keep an open mind 😉
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato