CSV with Header to Database in a DTS package

#1

I have a CSV file which has a line (kind of comment ) in the first row and
the last row ,I'd like to use Datapump to trnasfer its data to a Table but I
don't know how to eliminate those two lines.

Any suggestion?

Thanks

#2

If you look at the properties of the datapump on the options tab, there is a
textbox where you can set the first row and last row to transfer. I would
guess you could set the first row = 2 and the last row to the number of lines
in your CSV - 1 thru code.

"RayAll" wrote:

Quote:

I have a CSV file which has a line (kind of comment ) in the first row and
the last row ,I'd like to use Datapump to trnasfer its data to a Table but I
don't know how to eliminate those two lines.

Any suggestion?

Thanks

#3

My problem in this solution is that I don't know that how many rows are
there in each CSV file so I can't explicitly set the last row.

Thanks for your help,

Ali-R
"ddobier" <ddobier (AT) discussions (DOT) microsoft.com> wrote

Quote:

If you look at the properties of the datapump on the options tab, there is
a
textbox where you can set the first row and last row to transfer. I would
guess you could set the first row = 2 and the last row to the number of
lines
in your CSV - 1 thru code.

"RayAll" wrote:

I have a CSV file which has a line (kind of comment ) in the first row
and
the last row ,I'd like to use Datapump to trnasfer its data to a Table
but I
don't know how to eliminate those two lines.

Any suggestion?

Thanks

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

CSV with Header to Database in a DTS package

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

CSV with Header to Database in a DTS package - 03-02-2005 , 11:25 AM

RE: CSV with Header to Database in a DTS package - 03-02-2005 , 12:41 PM

Re: CSV with Header to Database in a DTS package - 03-02-2005 , 02:57 PM