Exporting to Excel leaves one empty row after title (but only if it exports one column!)
<p>I have the following problem. I'm exporting to an Excel 2003 file (<em>has to be</em> Excel 2003) from SQL Server through SSIS. It first creates a sheet through a SQL Task and then populates it with a SQL Data Flow. The Excel connection specifies that the first row has the column names.</p>

<p>The problem I have is that when the sheet only has one column, SSIS starts writing not in row 2, but row 3.</p>

<p>This is the SQL script that creates the sheet:</p>

<pre><code>CREATE TABLE `Sheet1` (`Column` LongText)
</code></pre>

<p>And the script that populates it:</p>

<pre><code>SELECT socialSecNum FROM Users
</code></pre>

<p>If I add a dummy column, with name ".", and in the DataFlow fill it with blanks, it doesn't skip that row, and starts writing in row 2.</p>

<p>The SQL Task script that creates the sheet in this case is:</p>

<pre><code>CREATE TABLE `Sheet1` (`Column` LongText, `.` LongText)
</code></pre>

<p>It's the same SQL script that fills the Excel file in both screenshots. The output doesn't change, so there isn't a NULL value being inserted randomly at the beginning there.</p>

<p>What is going on? How do I avoid it? I can't have that "." column name there.</p>

<p>EDIT: Also note that it's not that the Excel files are dirty and that's why it leaves an empty row in row 2 because it thinks it's being used; the same file doesn't skip a row if I add a second column in the script.</p>

<p>EDIT2: I was asked to remove the pictures, sorry.  </p>