Export (0) Print
Expand All
Expand Minimize
0 out of 1 rated this helpful - Rate this topic

How to retrieve the row value data (Enterprise Manager)

SQL Server 2000

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.
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.