ActiveX Script Task
If you have used DTS 2000, you might have used the ActiveX Script task to extend your DTS packages. This powerful task was provided in DTS 2000 and helped database developers to develop packages that otherwise wouldn’t be possible. Many database developers and information analysts have exploited this task to customize data transformation; apply business logic in the DTS package; manage files and folders; dynamically set properties on tasks, connections, or global variables; and perform complex computations on the data. To help smooth migration from DTS 2000 to SSIS, Microsoft provided the ActiveX Script task in SSIS to run those custom-build scripts until such time when the scripts can be upgraded to a more advanced scripting ...
Get Hands-On Microsoft SQL Server™ 2005 Integration Services now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
