Microsoft® ActiveX® scripts can be used to perform many useful DTS tasks ranging from simple transformations to complex multiple-key database lookups. These scripts can be implemented using the DTS Import and DTS Export wizards and DTS Designer in SQL Server Enterprise Manager. They can also be implemented programmatically using the DTS ActiveXScriptTask object. For more information about ActiveX scripts and additional examples, see Using ActiveX Scripts.
DTS ActiveX script samples illustrate how to use ActiveX scripts to: