SSIS Tutorial Part 23-Read Files as per Extension & Load them to a SQL Server Table in SSIS Package

I enjoyed watching this video and recommend others

Host explained how to move the data from Multiple .txt files which has same meta data to SQL Server table.

Thanks for educating the community.

Hi I love your blog, I have a question but i did not find answer to that. My question is how to load multiple flat files into respective destination tables(like hundreds of files) using same ssis package. Each file has different matadata..Please help me

Hi Aamir,
I'm trying to connect integration services but i am getting this error Invalid server name "(LocalDb)\MSSQLLocalDB". SSIS service does not support multi-instance, use just server name instead of "server name\instance".
I'm using Sql server 2016
this is my server name :(LocalDb)\MSSQLLocalDB
Any help would be appreciate.

Thanks a lot

Why the same approach is not working for the Excelfile.If possible please upload for excel.