Share via

Skip five rows when loading data

Su Si 60 Reputation points
2024-11-25T07:06:48.4633333+00:00

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

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,148 questions
0 comments
Accepted answer
  1. ZoeHui-MSFT 38,621 Reputation points
    2024-11-25T07:13:01.73+00:00

    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.

    User's image

    Regards，

    Zoe Hui

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

    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.