How to retrieve the row value data (Enterprise Manager)

To retrieve the row value data

1. From the Task toolbar, drag a Microsoft® ActiveX® Script task onto the Data Transformation Services (DTS) design sheet.
   
   
2. In the ActiveX Script Properties dialog box, after the Function Main() statement, type the following Microsoft Visual Basic® Scripting Editing (VBScript) code:

   MsgBox "The author ID is " & DTSGlobalVariables("o_au_id").value
   MsgBox "The title ID is " & DTSGlobalVariables("o_title_id").value
   MsgBox "The au_ord is " & DTSGlobalVariables("o_au_ord").value
   MsgBox "The royalty is " & DTSGlobalVariables("o_royaltyper").value
   
   Main = DTSTaskExecResult_Success
   

3. On the design sheet, click the Execute SQL task, and then CTRL-click the ActiveX Script task.
   
   
4. On the Workflow menu, click On Success or On Completion.