hi, how can I use a variable in ssis. I try to do this code in ssis :

set @app = (select Application from dbo.Table_1 where [db]='aa1')

I declare a variable is...