Home Library Learn Samples Downloads Support Community Forums
MSDN Library
Servers and Enterprise Development
SQL Server
SQL Server 2008 R2
Product Documentation
SQL Server 2008 R2 Books Online
Integration Services
Technical Reference
Feature Reference
Integration Services F1 Help
SSIS Designer F1 Help
Task Properties UI Reference
ActiveX Script Task Editor (General Page)
ActiveX Script Task Editor (Script Page)
Analysis Services Execute DDL Task Editor (General Page)
Analysis Services Execute DDL Task Editor (DDL Page)
Analysis Services Processing Task Editor (General Page)
Analysis Services Processing Task Editor (Analysis Services Page)
Bulk Insert Task Editor (General Page)
Bulk Insert Task Editor (Connection Page)
Bulk Insert Task Editor (Options Page)
Data Mining Query Task Editor (Mining Model Tab)
Data Mining Query Task Editor (Query Tab)
Data Mining Query Task Editor (Output Tab)
Data Profiling Task Editor (General Page)
Single Table Quick Profile Form (Data Profiling Task)
Data Profiling Task Editor (Profile Requests Page)
Destination Database Files
Execute DTS 2000 Package Task Editor (General Page)
Execute DTS 2000 Package Task Editor (Inner Variables Page)
Execute DTS 2000 Package Task Editor (Outer Variables Page)
Execute Package Task Editor (General Page)
Execute Package Task Editor (Package Page)
Execute Process Task Editor (General Page)
Execute Process Task Editor (Process Page)
Execute SQL Task Editor (General Page)
Execute SQL Task Editor (Parameter Mapping Page)
Execute SQL Task Editor (Result Set Page)
File System Task Editor (General Page)
FTP Task Editor (General Page)
FTP Task Editor (File Transfer Page)
Message Queue Task Editor (General Page)
Message Queue Task Editor (Receive Page)
Message Queue Task Editor (Send Page)
Script Task Editor (General Page)
Script Task Editor (Script Page)
Select Objects to Transfer
Select Variables Page
Send Mail Task Editor (General Page)
Send Mail Task Editor (Mail Page)
Source database files
Transfer Database Task Editor (General Page)
Transfer Database Task Editor (Databases Page)
Transfer Error Messages Task Editor (General Page)
Transfer Error Messages Task Editor (Messages Page)
Transfer Jobs Task Editor (General Page)
Transfer Jobs Task Editor (Jobs Page)
Transfer Logins Task Editor (General Page)
Transfer Logins Task Editor (Logins Page)
Transfer SQL Server Objects Task Editor (General Page)
Transfer SQL Server Objects Task Editor (Objects Page)
Transfer Master Stored Procedures Task Editor (General Page)
Transfer Master Stored Procedures Task Editor (Stored Procedures Page)
Web Service Task Editor (General Page)
Web Service Task Editor (Input Page)
Web Service Task Editor (Output Page)
WMI Data Reader Task Editor (General Page)
WMI Data Reader Task Editor (WMI Options Page)
WMI Event Watcher Task Editor (General Page)
WMI Event Watcher Task Editor (WMI Options Page)
XML Task Editor (General Page)
Expand Minimize
0 out of 1 rated this helpful - Rate this topic

Execute SQL Task Editor (Result Set Page)

SQL Server 2008 R2

Use the Result Set page of the Execute SQL Task Editor dialog to map the result of the SQL statement to new or existing variables. The options in this dialog box are disabled if ResultSet on the General page is set to None.

For more information about this task, see SSIS Execute SQL Task and Working with Result Sets in the Execute SQL Task.

Result Name

After you have added a result set mapping set by clicking Add, provide a name for the result. Depending on the result set type, you must use specific result names.

If the result set type is Single row, you can use either the name of a column returned by the query or the number that represents the position of a column in the column list of a column returned by the query.

If the result set type is Full result set or XML, you must use 0 as the result set name.

Related Topics: Working with Result Sets in the Execute SQL Task

Variable Name

Map the result set to a variable by selecting a variable or click <New variable...> to add a new variable by using the Add Variable dialog box.

Add

Click to add a result set mapping.

Remove

Select a result set mapping in the list and then click Remove.

Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.
|
Site Feedback
© 2013 Microsoft. All rights reserved.