Difference between Output Parameter and Result Set in execute sql task

Result Sets and output parameters are not the same.

Result Set

ResultSets are used to store a result of a Select query: It can be a one or more columns and it can be a single row or a full result set or XML. ResultSets are retrieved as ADO ResultSets and can be stored within variables. It may be

It is in General tab.

None: Insert, update, delete, create, drop or truncate

Single Row: store the single row only

Full result set: stored full result. Data type will be the object type variable.

XML: to store the XML type records.

Output Parameters or return value

Output Parameters are used to store some values that can be set any part of the SQL command. Parameters have the same concept of a SQL stored procedure parameters.

We will get it in the parameter mapping

  

Read more about:

Read: CallStored Procedure in execute sql task in SSIS

https://bageshkumarbagi-msbi.blogspot.com/2019/11/call-stored-procedure-in-execute-sql.html

Read: Outputdirection in execute sql task in SSIS

https://bageshkumarbagi-msbi.blogspot.com/2019/11/output-direction-in-execute-sql-task-in.html

Read: ReturnValuedirection in execute sql task in SSIS

https://bageshkumarbagi-msbi.blogspot.com/2019/11/returnvalue-direction-in-execute-sql.html