In SSIS, is it possible to save a value within a Data Flow Task into a Variable?
I have a value which comes from a SQL query against an Excel file. I want to save that value into a variable. I have been able to get that value using Excel Source component. What should I do next? Thanks.