Using Data Transformation Services, part 3: Using the DTS Designer Objects (continued) - Set up an ActiveX Script Task to access the text file
(Page 4 of 9 )
The ActiveX Script Task can be chosen from the menu item Task. Click on Task to choose the ActiveX Script Task from the drop down menu. It can also be chosen from the Task collection icons as shown in this picture.
Drag and drop the ActiveX Script object on the editor's design pane (named as HelloDTS in this tutorial). After adding this object the design pane appears as follows:
The addition of the ActiveX scripting object opens up the ActiveX Script Task Properties window, where the scripting has to be carried out, as shown. It pops up the default function Main. The default function always produces a success. Although the default language is VB Script, several other languages can be chosen as shown in the dropdown box.
The following picture shows the functions which are accessible using PerlScript. For this tutorial the default VB Script is used.
l
Next: The FileSystemObject >>
More MS SQL Server Articles
More By Jayaram Krishnaswamy
