How to import multiple excel sheets in an excel source to SQL using SSIS?

0
votes

How to import multiple excel sheets in an excel source to SQL using SSIS?

I will have to import multiple excel files and each file has 8 sheets. Number of sheets on all the input files remains same.

  • Each Sheet will be imported to each table.
  • Each sheet will have different row # ( Sheet1$A:K, Sheet2$A3:F ..) to start the import process.

How to set this setting in the Excel Source ?

1
sql-serverexcelssisetlsql-server-data-tools
If all the sheets have the same name, in all the files, you could do this with 8 sources (and destinations if they're going to different tables) in you Dataflow Task, and use a ForEach Loop on the directory they are stored in. – Larnu
After all of that you just delete your question? I hope you solved your issue but I also hope you realise you have a bad reputation – Nick.McDermaid
I agree with you, Thank you – goofyui

1 Answers

1
votes

If you are looking to import all sheets in an Excel workbook into SQL you can refer to the following links:

But you must notice that if the excel worksheets have different structures, then you should create multiple excel source, also if loop through many excel files you should create a foreach loop container to loop over files and inside it you should create another foreach loop container to loop over worksheets.