sql server - Setting multiple variables from a Execute SQL Task result object with a single row -

sql server - Setting multiple variables from a Execute SQL Task result object with a single row -

i have next sql in execute sql task:

select [cnxnstrvalue1] int_support_cnxnstr ,[cnxnstrvalue2] lawson_cnxnstr ,[cnxnstrvalue3] lawson_hris_cnxnstr [dbo].[interfacedbcnxn] interfacename = ?

the result set set object variable. have 3 string variables hold values , typically map them each loop container. but, in case, result set 1 row because interfacename primary key of table.

whats best way set variables out using each loop container?

change result set full single row. utilize pattern dw loads surrogate key value unknown members.

resultset set single row

map parameters needed. here, have 8 variables mapped

sql-server ssis