Hi @NoviceDBA9,
Check it out here: https://www.mssqltips.com/sqlservertip/4150/how-to-read-data-from-an-excel-file-starting-from-the-nth-row-with-sql-server-integration-services/
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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
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.
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 !!