91 How to import multiple excel file with different sheet name using SSIS

How to import multiple excel file with different sheet name using SSIS

Download the file\script used in the Video from below link

How to import multiple excel file with different sheet name using SSIS
How do I import multiple files into SSIS?

Happy Learning.

[OleYoule]

Nothing can work without $ Bro) Thanks for useful video tutorial 👍

[yonisupersaiyanyoni]

Also inteop don't work when I diploy the package, and it's not permission problem, the sql agent have permission to the folder and excel file. Is there a way without code?

[kristy.rlopez]

Thank you so much for sharing this tutorial! Everything ran well but I was prompted with a window if I wanted to save changes to each file each time it was processed. How can we prevent this from happening or to automate the respond to "Yes"?

[soumyabhat]

after doing all the steps still its not working

[blackisblack]

What if destination table depends on Sheet name? For example, we have A to E tables with different structures, one Excel file with tabs [A, C, D] and another [A, B, E]. How could we send data to the right table dynamically?

[harimsbi]

Is it allow to read excel files from ssis package like space values present in Excel Sheet Name like (Annual Report)

[soumyabhat]

could not find Microsoft Excel 16.0 object library in references part of Script task

[danialilyasak]

Hi, I try to search reference Micorsoft excel object library but there is no item found.

[Stan-tbqz]

Hi this video is amazing! But what if the excel file is a csv? I followed all steps until the part of making sheet name dynamic in excel source because I have a flat file source...

[kanikeveeresh]

Good morning sir.
Your explanation is very nice but I don't about c# code then how can I do it without script task in ssis.

[soumyabhat]

how to add Microsoft Excel 16.0 object library

[pns]

what if there are multiple sheets in the excel file and I would like to import all the sheets ?

[backgrounding]

Hello, how about multiple excel files and all of them have the same Sheet's Name?

[soumyabhat]

[Excel Source [2]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
[Excel Source [2]] Error: Opening a rowset for "a1_BK26_RFBILA00_2020$" failed. Check that the object exists in the database.
[SSIS.Pipeline] Error: "Excel Source" failed validation and returned validation status "VS_ISBROKEN".


The first file rund but the second fine sheet name is a2_BK26_RFBILA00_2020 for this getting above error