SSIS Tutorial Part 25-Load Multiple Excel Files to SQL Server Table & Archive them with Datetime 

You have saved 10+ hours working for this tutorial. Thanks alot.

Your video is amazing. That set validation to true section solved an issue that I have been having for the past day. You good sir are the BEST!!!!! :)

Great job Amir! This guide was very helpful, I always worked with txt files, but with excel ones is slightly different. Greetings from Lima

Excellent explanation

I like this video and re-watched since it contains lots of file handling cum data moving. Definitely this kind of work is is required in day to day. I recommend others to watch. Thanks for educating. Thanks a lot

This video is detail oriented. Thanks.

your video is so clear. thank you very much

Your video is very clear and helpful

thank you my friend your video helped quite alot !

Great work, even though i had difficulties grasping towards the end of the video. My challenge comes with variables and the fact that my input folders are more than one (seven network computers) which are all imported into seven identical SQL tables. The archive folder is one though.

Thanks!

Hi Aamir , Why does rename file operation move the files to the new Archive Path? , Thanks

Thanks for the excellent video. It was a great help.

genius. life and time saver. thanks a ton

Excellent !!! Respect

Very helpful! SSIS is a great tool, but it's incredibly unintuitive and quirky as hell. Thanks for the video.

Fantastic logical guide - thanks for this!

Directory option in forech container is not showing

This is an important to all developers who handle Excel files. Functionality explained well and I like it and recommend to others. Question If I have an Excel file with three sheets with same data like yours then I need to use Excel Source three times configuring each sheet and use Merge Transformation and write it to my table in database without File Archiving, am I right? Thanks

This is a very good video. I followed the instruction and it worked like a charm. However, when new Excels file lands on the source folder with same schema, it does not work any more. For instance, after archiving file1.xlsx and re-run the package with file2.xlsx (from source), if fails with 'Opening rowset for "Sheet1$" failed....Excel Source" failed validation.... any idea? Thanks

Great !!! Your video really amazing. I have one question,could you please help me to resolve. Actually want to develop a SSIS package for importing Customer where the data is provided from multiple flat file sources. The customer primary data like customer id, name from one file and address information from different file source. The customer address data also contain multiple address information for each customer. need to get the latest customer information and merge it with customer primary data and import it into destionation customer table. How to design such a logic and it must be recent customer infomation is imported ? Please explain by drawing a diagram.

Is there any tutorial to load data from multiple excel workbooks (each workbook can contain data in different worksheets). Number of columns will be same. ...???

Revisited since I like this video and it has real time application. I wanted to learn this technique. Recommend others to watch. How about Foreachloop for each file to pick up then another Foreachloop to read each sheet in the Excel file and load the data in to database? It's only my thought and implications to be studied. Any suggestions? Thanks for educating the community. Thanks a bunch

Awesome tutorial! Thank you for posting.

Well done sir , great information

this fails when my sheet has same table structure but different sheet names. i have files downloaded from server where the sheet name changes the as per the day i download the file. Can you please make a video on it.

My Excel Filenames are in sql table and i need to get the fileid and save this id along with the data in excel file to another sql table. how can this be achieved?

Please, How to import multi excel file, csv file and text file into multi difference table in SQL? Thanks very much!!!

Great! What if I'd like to save the filename of each file into sql table so that I could know from which file the data was coming from, how can I make that work? Thanks

Hi TechBrothers, Good job. If any possible for automatically upload excel file to SQL server(for example: when i paste the excel file into the inputfolder that excel file automatically saved to SQL Table)

Thanks for the Video !

Hi, I have followed your method for loading multiple files. When i used both the variables file and inputfolder the package is failing.when I just use the file name it works. Can you tell why this might have happened?

Hello TechBrother, I have a quick question regarding the variable used in foreach container. so you want every file and every extension in the file, but why you just use one parameter 'FileName' but you are using '*.*' when you configure the foreach container?

Thanks, i have a question, In this case, if posible to change the excel? because in my case i have the same information but in different dates like, excelfile_202101.xls to excelfile_202102

Good day, What happen if the excel file has many columns and the excel source task doesn't take all of them?

Awesome tutorial.. very helpful... can we valid the sequence and the columns name of excel sheet for each excel file using SSIS

Very helpful tutorial, thank you. How to archive to different folder?

I was trying to get the filenames and write into a txt file. But the issue is i am getting only one filename in txt file. What could be the problem anyone can help. Thanks

I have excel files where the tab names differs always, how can I make it dynamic?

muito bom!!!! salvou minha carreira /;d

Hi guys, Can you please help me to understand how can I load multiple xlsx files to different sql server tables? Example Customer.xlsx -> dbo.csutomer AND Orders.xlsx -> dbo.Orders. Thnaks in advance

sir can you please explain excel source errors

Awsome tutorial..Thanks for posting. I created the package after referring to this video. I have 5 excel files with same column names over these 5 files. Once the package is executed I see the content of First file into Sql server 5 times. My foreach loop container is iterating through the same file 5 times. Can you please let me know what am I missing? Thanks in advance.

Hi, Helpful Video. I have a question though! In excel connection manger properties, to read the data from different files, why can't we change the connection string property in the expression rather than changing the excel file path property? Will it lead to any issue?

Thanks for the video. I created the package and doing exactly as in your video but the package is picking the same file again and again. Why?

Hi Team, the same way please explain how to load multiple ms access files to SQL server. All Access files having single table and same structure. Please help !

Hi, I have few query regarding the import data from excel files. import multiple files with same schema data (like column names, data types) which have same table name in each files in a folder. the table is start from column C and row 10 due to some formatting and analysis. Is there any way to import them into SQL server through SSIS directly from the tables or defined named range? Another query is regarding importing data from excel- I have 64bit SQL Server & Excel 2016, but Visual Studio is 32 bit. While I create package for excel import my excel connection manager show an error Microsoft Visual Studio ------------------------------ Could not retrieve the table information for the connection manager 'Excel Connection Manager'. Failed to connect to the source using the connection manager 'Excel Connection Manager' Can you help me with this?

Sir i have built the package its runs fine. but cannot deploy the package i am some errors

Can I get a download link for the SSIS package in this video?

Whole container failed..wt I am do

Unable to play this video

Job runs through visual studio but not through sql server agent job.

How to load xls & xlsx files simultaneously using a single DFT, please revert if anyone have developed such package.

Nice Video..But i don't know why i am getting Error while doing the same as you did in this video. SSIS ERROR CODE DTS_E_OLEDBERROR, Am OLE DB error has occurred. Error Code: 0X80040E37. can you please help in the same ?. Thanks ans god Bless you.

This doesn't work