title: SSIS package doesn't write data to excel destination
body: <p>I have an simple SSIS package and I'm trying to export same set of data from a table to both flat file and excel destination. The package works fine when I run locally and it creates both text file and excel file with data. </p>
  
  <p>But when deployed to a different server the sql agent job runs fine and the log inside integrations services catalog for the package says it wrote like 9000 rows to excel, and a new excel file is also created but it doesn't write any data to it(blank with just headers). text file works fine and it has all data I need.  </p>
  
  <p>SSIS package flow:</p>
  
  <p><a href="https://i.stack.imgur.com/1ZQUl.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/1ZQUl.png" alt="Screenshot"></a></p>
  
  <p>I'm working with Sql server 2014, Visual studio 2013 with SSDT and used Excel 2007 in excel destination. </p>