Avoid ActiveX Scripts
Whenever possible, avoid scripts. Copy operations are 25 to 50 percent faster than scripts written in VBScript. Scripts written in VBScript are about 10 percent faster than scripts written in JScript, which are about 10 percent faster than scripts written in PerlScript.
Using column names helps you document your script, but at a small performance impact. For example, most people use DTSSource("PlantID") rather than DTSSource(1). However, if the source or destination has more than 20 columns, using the column index may provide a noticeable performance impact.