Loading multiple Excel files using SSIS removing first 5 rows

NoviceDBA9 41 Reputation points
2023-02-01T18:35:50.44+00:00

Hello Forum,

Would like to know if there is a way in SSIS or Powershell to removed first 5 rows in Excel and load the remaining , meaning starting for the 6th row to the table . Have multiple Excel files that need to be loaded .

Thanks in advance

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,436 questions
0 comments No comments
{count} votes

2 additional answers

Sort by: Most helpful
  1. ZoeHui-MSFT 32,001 Reputation points
    2023-02-02T02:15:38.32+00:00

    Hi @NoviceDBA9,

    You may refer to the article that Yitzhak Khabinsky mentioned to skip the rows in excel source.

    If you want to load multiple Excel files in SSIS, please check Import data from multiple Excel files into SQL Server tables using an SSIS package

    Regards,

    Zoe Hui


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

    0 comments No comments

  2. NoviceDBA9 41 Reputation points
    2023-02-02T04:38:45.73+00:00

    Thanks Yitzhak Khabinsky & Zoe Hui appreciate all your help .. I'm following both the suggestions and see what they want to do .. thnx a lot !!

    0 comments No comments