Passing in/out parameters using Execute SQL task in SSIs/ETL

 

Variable settings: fieldout and fieldinput

SQL statement: Select top 1 outfieldname from table where field =?

Step 2: In general, set resultset to single row, sqlstatement: Select top 1 outfieldname from table where field =?

Add a variable in parameter mapping: vaiable name: User: fieldinput direction: Input datetype: nvarchar Parameter Name: @ field (this @ is the key)

In result set: a variable: Result name: outfieldname vaiable name: User: fieldout is also added.

The execution should be successful. This execution will check the rows of field = fieldinput and pass the value of outfieldname to the fieldout variable.