143 How to import multiple excel files into sql server using ssis

How to import multiple excel files into sql server using ssis
Download the file\script used in the Video from below link

How to import multiple excel files into sql server using ssis
How do I import multiple Excel spreadsheets into SQL Server using SSIS?
How do I import multiple Excel files into different SSIS packages?
How do you bulk insert Excel file in SQL Server?
How do I load multiple files in SSIS?

[ArwaAldoudOmer]

Thanks, it was amazing. I followed the steps and it worked perfectly. Thank you 🥰

[lonestarparrot]

Great tutorial and very easy to follow!!! Thanks @Learn SSIS

[shival]

Excellent one. Please do a video on importing multiple excel files into sql server as separate tables with scheduled incremental refresh.

[sureshareti]

Good one bhaiyya... Thanks alot.... I request you do one video on Source Excel Read all excel header with data dynamically based on that create table dynamically in sql server and map columns dynamically excel source and sql server destination and load the data

[lifeisawesome]

Thanks for this great tutorial.
I have a question: If files are in SharePoint, is this approach will work?

[shaneparkes]

Thank you, I would move uploaded files to another folder instead, this should help if ever a file needs to be replaced, not sure how it will handle when there is no file present though. I will also add an identifier to the filename to avoid duplicate filenames

[prashantsinhaus]

Thanks, It was good and all easily understandable

[LocNguyen-crtm]

why I see no any data connection afer clik "new" in OLE DB connection manager step ?? help me please

[afiqghazali]

Hi there, great tutorial.

In minute 4:59 you selected ExcelFilePath and the expression is User::FilePath.
If im flat file source(.csv), what option should I choose?

[samderrty]

the microsoft access database engine cannot open or write to the file. But I do not have it opened. any ideas?

[iNtellectual.paradoX]

Bro when i select excel with xlsx extenstion in excel source I do not get name of excel sheet.it says no table or view could be loaded. same is working fine with .xls extention.
Plz help.

[HeadshotAndCruise]

I am Getting below mentioned two error while importing multiple excels. When I run the package the data in excel mentioned in log got imported and the package terminates with the following error. Can you please suggest what wrong I am doing.
[Excel Source [84]] Error: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80004005.
[Excel Source [84]] Error: Opening a rowset for "MASTER_FEB_2024$" failed. Check that the object exists in the database.

[beyzanuraltikardes]

I want to do this for excel files in different folders in the same project for example with 2-3 foreach loop containers. is it possible?

[farzadsaedi]

Very good tutorial. Can you please show how multiple excel file can be transferred from SharePoint folder to Sql Server? thanks

[ziadbensaada]

not working for me! it import one file only in sql server with flag x in the schema of excel source ? i dont know whaat is the problem?

[putrigilang]

Hi I've edited the expression and it turns out error "the acquire connection method call to the connection manager failed with error code 0xC0202009" can you help me with this?

[vochau]

Hello, I build a SSAS to load data from SQL server. Firstly, I load fact table 500 lines. I deploy SSAS also load 500 lines. However, when I update the fact table by SSIS increate to 600 lines. SSAS does not load enough to 600 line. I have to process SSAS again, it loaded to 600 lines. But when I deploy SSAS again, it still loads 500 lines. Therefore, the Excel report does not refresh. How do I fix this. Thank you for your help

[funbutterjam]

We have 3 tables it have millions record. so last 3 year before data move source to stg table and then stg to archival and delete record from source and stg table after moved archival (source and stg table same server but archival is different server). How to create siss package. please make one video.

[priyavishalkulkarni]

The same steps are followed.
The only difference is that I have a CSV file.

But getting data from only the first file.Not the second one.
And if I execute the package again then the same rows are added repeatedly.

[vochau]

Do you have a video that load Dim and Fact table from an Excel file. For example, I have a E-com data, I want to load to Dim and Fact table. Thank you so much