sql - Setting a variable with multiple rows in SSIS -

this question has answer here:

• which best way form string value using column table rows having same id? 2 answers

i need in ssis:

from 1 sql table need id values, using simple sql query:

select id identifier value not null.

i've got result:

as final result need generate , set variable in ssis final value:

@var = '198','120','acp','120','pqu'

which need use later in odbc expression.

is possible in ssis?

just clarify: image little example of can first part of process. mean, number of id need unknown.

use simple query

declare @test table(id nvarchar(10)) insert @test values('186'), ('120'), ('acp'), ('120'), ('pqu')  declare @id varchar(8000)  select @id = concat(coalesce(@id + ',''', ''''), id, '''') @test  select @id 

result

'186','120','acp','120','pqu'