Can I just Import several Rows from Text files

[znet]

Hello friends,
I hope import the first several Rows from a Text files to database, because the first row just stores column name, I want analyses it in advance. Anyone give me a direction, I am just starting to learn DTS. Thanks

 

[SimeonJ]

If the text file is an excel file, yes, you can import only a specific number of rows. You just query the excel file and then insert into the database table.

If the file is a basic TXT file or the like, I would recommend first importing that file into an excel file and then query/insert into the excel file if you only want to pull a few rows from that file.

 

[znet]

Thanks SimeonJ,
Actually I find solution, Set first row and last row in DTS.