title: How to read variable's value in Excel spreadsheet using SSIS
body: <p>NoI have an SSIS package that transfer and archive files every 4 hours. Inside of that package I have execute SQL Task that execute stored procedure in which I'm calling one column from Archive table. My stored procedure works and every time I run the project with breakpoints I can see that a variable is getting the column's value. 
  The next step I need to do is to transfer that value into Excel Spreadsheet. For that I created Data Flow Task with Excel Source, Derived Column and Excel Destination. Excel Source File is just a temporary file with no data in it, so in Derived Column task I'm replacing 'F1' column with user variable and in Destination File I'm mapping that value with the right column. 
  Every time I run the package I get a successful run, but my Destination File is empty. I don't know what I'm doing wrong, I tried every possible option but it doesn't work. 
  <a href="https://i.stack.imgur.com/nXMJD.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/nXMJD.png" alt="Control Flow"></a></p>
  
  <p>[<a href="https://i.stack.imgur.com/Th6Dp.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Th6Dp.png" alt="Data Flow Task-Derived Column Task]"></a></p>