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, i am very much sure, I have this scenario. Here is one that is close to your requirement www.techbrothersit.com/2016/04/how-to-load-flat-files-to-sql-server.html
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.
When integration services was installed, did you add it to existing instance or you installed it separate? Please go to sql configurations and look at integration services to see if it shows instance name in parentheses? If so use server name and that instance name, if it’s just installed without instance, select integration services from SSMS and just put server name, you should be able to connect. Try also putting (.) dot in the server name, it will pick up local server name on its own.
@@TechBrothersIT my question for this video is, if i want to load .txt files into one sql table, .csv tables into one sql table, and .xls files into another sql table, how can i do this, i thought of taking 3 for each loop containers in CF, please correct me if i am wrong
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.
Thanks a lot
Why the same approach is not working for the Excelfile.If possible please upload for excel.
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, i am very much sure, I have this scenario. Here is one that is close to your requirement www.techbrothersit.com/2016/04/how-to-load-flat-files-to-sql-server.html
here you go , this should do it. www.techbrothersit.com/2016/03/how-to-create-tables-dynamically-from.html
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.
When integration services was installed, did you add it to existing instance or you installed it separate? Please go to sql configurations and look at integration services to see if it shows instance name in parentheses? If so use server name and that instance name, if it’s just installed without instance, select integration services from SSMS and just put server name, you should be able to connect. Try also putting (.) dot in the server name, it will pick up local server name on its own.
TechBrothersIT sure will try thanks for your response
@@TechBrothersIT my question for this video is, if i want to load .txt files into one sql table, .csv tables into one sql table, and .xls files into another sql table, how can i do this, i thought of taking 3 for each loop containers in CF, please correct me if i am wrong