Skip five rows when loading data

Question

Is it possible to skip the top5 rows when loading data from flat file to sql table in SSIS

Answer 1

Hi @Su Si,

When you create the flat file connection manager, you will see the option named 'Header rows to skip'

You may enter 5 in the property to meet your requirement.

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.