Hi,

a client privide me a cvs file with report tile (1th row) and column name
(2nd row) and following by all the corresponding data. 

In DTS, you only has two choice 1) Skip ## rows 2) First row have columns
name.  If I skip 2 rows, then I can keep the column name.  If I choose skip
one row and click first row has columns name, the data won't import correctly
either.  So, my goal is
1) I don't need the first row (report tile)
2) I would like to use the column name in the 2nd row

How can I achive this goal?  Thank you.

Why not just remove the first two rows from the file before using it as the
source?

yes, that's what I do right now.  But, the name of source column will just
show col001 ~ col126.  My goal is that I want to see the column name.  So, I
can do it by deleting the first row and then click First row has column name
option.  But, the file will update daily and I want to make it automatically.

Show quoteHide quote

Sum Total Hours and Minutes in a report
Aggregate Function Error
unique variable per connection
RFC: EXISTS (SELECT ... FROM) optional?
use subquery result in Selet statement