title: How to use SSIS script task to delete second row in Excel destination? SQL Server 2012
body: <p>I have a simple package that extracts data from SQL Server and writes it to Excel spreadsheet.</p>
  
  <p><strong>Why am I doing this:</strong> the problem is that the value of one of the column is greater than 255 characters, which causes an error. I already tried different ways to find a solution, but so far without success. </p>
  
  <p>So I created dummy row in my Excel template that is able to accept more than 255 characters. After I load the data, I need to delete that dummy row. </p>
  
  <p>I do not know much about C#. How can I delete second row in Excel destination by using SSIS script task C#? Do I need to create variables that hold the path folder and file name?</p>
  
  <p>And then how can I map those variables to my C# code?</p>
  
  <p><a href="https://i.stack.imgur.com/uKAiT.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/uKAiT.png" alt="enter image description here"></a></p>
  
  <p><a href="https://i.stack.imgur.com/b9PJ2.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/b9PJ2.png" alt="enter image description here"></a></p>