How to Load Multiple Excel Files Data to SQL Data Table using SSIS Components [Live Example] 

Thank you bro ! This was helpful, I was missing delay validation and you video helped me lol , should have watched long back

Thank you so much. How to change this logic to read the files in parallel and load into the target in parallel instead of sequentially? The actual requirement is a SQL task prior to the Foreach Loop is feeding a list of databases against which same SQL has to be run in parallel (as the SQL runs for a long time) on all the databases that the Foreach Loop receives and the data extracted from each database should be loaded to the same target table in the target database.

very useful information, tq you so much mam. can you upload how to load text file to table in ssis

Nice Explination sir

Thank you Guru Sir.. Learned something new today.

Really helpful thank you ❤

Hi Sir, your efforts are commendable. Helping a lot to improve my skills. Could you please do more videos on Deployment and Configurations. Thank you

This is really helpful and it provides a lot of useful information. Would you please make a video on how to load multiple JSON files in SSIS using script component? Thank you!

Nice explanation sir. Can please upload the same but multiple excel files from different directory

do i have to give a db name while writing the truncate table query...as we are already ging it the database location *New to ETL*

How do you know your Excel version is 2016 on connection manager????

Liked your video. But in my case the Excel filenames are in an SQL table with some other data in that table. How to loop through this table and connect to the filenames and get data from these files to sql server.

Can you please suggest me how to load 10csv. Files into different tables through ssis? ( At the same time we need to create tables and different columns and different data) is it possible with single ssis package

Thanks for the detailed video, but just one thing is For me it's working for a single file but when I tried to do it for multiple, am facing this issue:"[Excel Source [2]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0209303. There may be error messages posted before this with more information on why the AcquireConnection method call failed".Any idea about this? Appreciate if you take sometime and reply

Hi sir, how load one Excel file have multiple sheets ,i need to load one sheet in table and second sheet into another table as & third sheet into another table, please make i video on this

Thank you Gurunath. Nice explanation. I am new to SSIS. I have 4 different sources and need to combine all into one target table in SQL server db. Can you please let me know how to proceed. I tried pulling all into one data flow task, then tried to merge join, but unable to do it. Here is the required columns from the 4 sources that needs to be in one target table. CUSTOMER_Info (SQL DB): Customer_ID, First_Name, Last_Name, Email, Phone_No Required All above Columns CUSTOMER Data (.txt file): First_Name, Last_Name, Age, DOB, Gender, Marital Status Required columns: Age, DOB, Gender, Marital Status CUSTOMER Address (.xls file): First_Name, Last_Name, Address1, Address2, City, State,zipcode Required columns: Address1, Address2, City, State, Zipcode CUSTOMER Region (.csv file): First_Name, Last_Name, State_Cd, Region Required columns: Region, State_Cd

Hello sir, i'm getting this error Failure inserting into the read-only column "CustomerID".

I have this error could you help me solve it SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB r....

hi sir , i m getting error in excel connection manager configuration , could you please tell me how to solve it .