sql server dts: Import CSV file but ignore first 10 rows -- sql server dts

Import CSV file but ignore first 10 rows

PizzaGood
9/28/2006 12:29:36 PM

sql server dts: Hi,

I am trying to build an automated process that would allow someone to upload
a CSV file via FTP to a specific folder and then the DTS package would do
it's thing every hour and import the information then delete the CSV file.

All of this is not a problem except that the first 9 rows contain a bunch of
misc. info that I do not want to include in the import. Let me explain:

*think of an Excel file as you read this and not a comma seperated file
- The CSV file has 20 columns
- The first 9 rows contain info like when the report was ran, which user,
server and so on. All of this information is put in the first cell of each
row, so the first 9 rows contain something in the first cell and then
followed by 19 blank cells
- the 10th row contains the column headings and I do not want to import
those either

Is there any way to skip the first 10 rows?

Thanks!!

Re: Import CSV file but ignore first 10 rows

PizzaGood
9/28/2006 5:17:46 PM

I guess I will just use the SKIP ROWS option I just saw.

[quoted text, click to view]