<div>
If you are going to skip the 8 header rows, than you need to uncheck the &quot;First row has column names&quot; check box.
</div>


If you are going to skip the 8 header rows, than you need to uncheck the "First row has column names" check box.

<div>
Hi,<br />
<br />
This option is not checked.
</div>


<div>
Than the only other thing would be if the first 8 rows did not use the same row delimiter as the rest of the file. &nbsp;If this is not the case, than post some sample data, that duplicates the problem.<br />
<br />
Also, please post a message in Community Support to have the following question deleted:<br />
<a href="https://www.experts-exchange.com/questions/21744038/skip-rows-dts-text-source-file.html" rel="ugc nofollow">https://www.experts-exchange.com/questions/21744038/skip-rows-dts-text-source-file.html</a>
</div>


Than the only other thing would be if the first 8 rows did not use the same row delimiter as the rest of the file.  If this is not the case, than post some sample data, that duplicates the problem.

Also, please post a message in Community Support to have the following question deleted:
https://www.experts-exchange.com/questions/21744038/skip-rows-dts-text-source-file.html [https://www.experts-exchange.com/questions/21744038/skip-rows-dts-text-source-file.html]

<div>
<div class="content wysiwyg-content">
 Hello,<br />
<br />
I have a source text file which contains 8 rows header.<br />
<br />
So in source text file properties i set the skip rows=8.<br />
<br />
Then i using the transform data task to transform the data into SQL table.<br />
<br />
But the result is that there are 8 rows of data also skipped.<br />
<br />
How can I solve this problem?<br />
Can I change the skip row properties in the transform data task?<br />
Can I use an activeX script to remove the first 8 lines of the file? How Can I do this?<br />
<br />
It's very urgent.<br />
<br />
Thanks in advance
</div>
</div>


 Hello,

I have a source text file which contains 8 rows header.

So in source text file properties i set the skip rows=8.

Then i using the transform data task to transform the data into SQL table.

But the result is that there are 8 rows of data also skipped.

How can I solve this problem?
Can I change the skip row properties in the transform data task?
Can I use an activeX script to remove the first 8 lines of the file? How Can I do this?

It's very urgent.

Thanks in advance

DTS Skip rows text file source

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.