I did exacly the same shown in the video and it worked with 17 files. Great content!
@nikolaybaranov2213
Жыл бұрын
An excellent solution for loading data from files with the same structure. Thanks, extremely helpful!
@TechBrothersIT
Жыл бұрын
Glad it was helpful!
@mkh9954
4 жыл бұрын
Thank you So much ! God Bless you Tech Brothers. keep making fantastic tutorials like this.
@juanvelasquez1167
6 жыл бұрын
This is an excellent series of videos. I'm just starting on SSIS and these videos are quite good. Thanks
@lakshmis2905
7 жыл бұрын
awesome videos and explanations.Keep sharing always!!!!!!!!!!!!!!!!!!
@sonjoysengupto
6 жыл бұрын
Very eloquent demo, and thanks a lot for sharing this ... Very helpful indeed!!!
@jen4770
9 жыл бұрын
Wonderful SSIS package demo video for education! Thank you so much.
@TechBrothersIT
9 жыл бұрын
+Jinyuan Xu You are welcome and thanks for watching!
@thirupathiambati3785
9 жыл бұрын
Nice video , i learn new thing in SSIS. Thanks...Aamir
@shivamothukuri5188
7 ай бұрын
Awesome video and explanation. I have one doubt in the above video. Why we have taken Excel path as Fullpath? Please answer
@dergimorka6126
5 жыл бұрын
THANK U VERY MUCH FOR UR TIME AND GOOD EXPLANATIONS
@alirezamogharabi8733
5 жыл бұрын
Very helpful, thanks a lot.
@jagdeepjulka1694
5 жыл бұрын
Thank you very much... sir for sharing your knowledge...
@devexpost8508
7 жыл бұрын
Amir, Thanks and well done on this series. Two notes on this one... 1. At 14:10 maybe it should be explained how looping is controlled by setting the Enumerator parameter to “Foreach File Enumerator”. 2. At 15:54 maybe it should be explained how user-variable “FullPath” is being assigned the Collection Value with Index=0. The mechanism is not clear. Best Regards.
@domfp133
8 жыл бұрын
Really nice video, i´ve been looking for something like this before, thanks bro.
@TechBrothersIT
8 жыл бұрын
+domfp133 You are welcome, Glad to hear you liked it.
@sonalisingh3183
7 ай бұрын
If you already configured your mutiple source and destination then what was the purpose of loop, how loop is helping. Can you please explain
@lksmhjn
8 жыл бұрын
thank you so much for that post its really helpful for me .. keep uploading.. thanks..
@TechBrothersIT
8 жыл бұрын
+Lokesh Mahajan You are welcome. Glad to hear that it was helpful.
@DharaStudies
4 жыл бұрын
Hi Amir, Really good, if you don't mind, can you please share something using one data flow task......
@krismaly
9 жыл бұрын
I enjoyed watching this video and recommend others to watch. Can we use Nested ForeachLoop so that Outer loop will be getting the file and inner loop will be reading sheets and inserting data to database? Thanks a bunch
@TechBrothersIT
9 жыл бұрын
You are right Kris, Nested Foreach Loop Containers can be used for the scenario you are asking. Thanks for watching and pointing out this.
@AmarKumar-kw9qy
9 жыл бұрын
TechBrothersIT can u please explain how we can do this using nested foreach loop
@krismaly6300
9 жыл бұрын
Amar Kumar Click to view and learn www.experts-exchange.com/articles/10658/How-to-Create-Ad-hoc-report-using-SSRS-and-SSAS-cube.html
@damaganesh3723
6 жыл бұрын
can you please share the link for this nested loop package
@kimiqin8923
5 жыл бұрын
Thank you so much~~ That's really clear and helpful!
@madhaviravoori6466
7 жыл бұрын
Thank you, it is really nice, very helpful to me.
@TechBrothersIT
7 жыл бұрын
+Madhavi Ravoori you are welcome. Glad to hear our effort was helpful. Thanks for watching.
@afonsosalreta4149
2 жыл бұрын
Great tutorial! In my scenario, I need to loop through all sheets of all files but the sheets and files are not the same. I tried to create 2 loops, 1 for the file enumerator and another for the sheets, but I can't make it work. Can you help me with that? To add to that I need to specify the cell range at each sheet that is different. 😂
@mohanpinagadi7870
8 жыл бұрын
Hi Amir I just want to know is there any video for this one using Script task for the Same Task
@hari9020
9 жыл бұрын
really worth watching. thanks a lot :) Is it possible to Export sql data to different excel file based on category ??
@imranpathan8352
3 жыл бұрын
hi..nice video.great help but i am working this task but not worked..it is second excel file not dumped data in sqlserver..please help waht issue?
@kushdevendra
8 жыл бұрын
great thanks a lot for videos....
@TechBrothersIT
8 жыл бұрын
+Devendra Kushwaha You are welcome dear. Glad to hear that you liked our effort.
@udaykaudgaonkar5481
7 жыл бұрын
Hello Amir, I have scenario , I have to load data from multiple excel file (having multiple sheet and same meta data) into single sql table using 1 (Single) DFT can you please tell the steps .
@AmarKumar-kw9qy
9 жыл бұрын
HI Aamir can u let me know is their any way to run multiple packages using a single execute package task
@Gudsan
3 жыл бұрын
Sir please tell me that how can I export adventureworks 2019's person table from SQL to excel
@zahidhossain8517
8 жыл бұрын
Will it work with flat files instead of excel files? I have some flat files to load some tables in db
@happyfeetdance2740
5 жыл бұрын
Hi Techbrothers, I am having trouble loading the excel data into SQL tables. The excel text column i have has alphanumeric values and when it is loaded in to SQL table value becomes NULL. I tried converting it using data conversion from float to string but it isnt working
@neerajbhanottt
8 жыл бұрын
Hi Amir , I have one doubt . I am trying to load two excels with 2 sheets per excel . Problem is i am able to load the second sheets but first sheet data is not getting loaded and when i put the data viewer in the data flow tab , i am able to see the data is moving toward OLEDB . so what can be the reason that data is not getting loaded to the OLEDB
@aenysatbhaiya8772
8 жыл бұрын
Since I am using excel files containing large data to load to one SQL server table, there are so many sheets in every excel workbook. After importing the excel files to SQL Server the rows of one sheet is getting mixed with another in the final table. How can we correct that so that data comes as it is in the excel workbook sheets?
@hari9020
8 жыл бұрын
It would be great if u make one deployment(SQL server) video for this package.
@TechBrothersIT
8 жыл бұрын
Hi Harish. Have plan for that. Will do for sure. Thanks for watching and feedback.
@sadana5b2
7 жыл бұрын
did you do encryption and decryption through ssis ?
@yamurkahtan
9 жыл бұрын
Thank you for useful video, but I want to load multiple individual Excel files to multiple data tables in the same database (e.g. filename = "abc" and oledb = "abc") then continue with teh same thing for 61 files. How can I do this? can I have some help?
@TechBrothersIT
9 жыл бұрын
Yamur Kahtan Does all the files has the same structure? If they have you can write expression on OLE DB Connection Manager to change the table name or you can use variable in the destination table name. IF they are different in structure and it will be hard to perform this. But I like the idea very much and I would come up with this solution once get chance.
@yamurkahtan
9 жыл бұрын
TechBrothersIT Thank you for answering. Actually, the files have the same structure. I realized the idea with the destination variable. It needs to match same tables names as files sources. I created the tables names the same as files names. I don't know how to modify the variable to match between the source and destination. I appreciate your solution as soon as possible. Thank you.
@yamurkahtan
9 жыл бұрын
Hi, I hope you have a time to add guideline about this scenario. I have tried but I didn't get anything. Thank you
@nagagannamaneni
8 жыл бұрын
nice one on the excels... lets say there are multiple sheets(about 30) on each of the excel file and lets say there are about 20 excel files. in such case, we can not create 30 DFT's for 30 sheets. So creating another FOR EACH LOOP for sheets inside the outer FOR EACH LOOP which runs for 20 excel files would work right.. ? Please correct me if I am wrong...
@TechBrothersIT
8 жыл бұрын
Hi, I have other videos in which i used C# with script task to handle those situations so you don't have to create these many DFTS. You will find them in the playlist.
@williampadilla2381
8 жыл бұрын
Nagababu Gannamaneni hjfgjjhkwoq
@jamesstewart6777
8 жыл бұрын
TechBrothersIT
@krishnendrabhattacharyya4609
7 жыл бұрын
if the name of the sheets are different in two files,will the package work?
@jyothiprasadmaddipati5677
3 жыл бұрын
Hi thanks for the content, but when running the package i am recieving error at "excel source", and error is as follows: [Connection manager "Excel Connection Manager 1"] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft Access Database Engine" Hresult: 0x80004005 Description: "External table is not in the expected format.". Any got resolution for this please help me out. thank you once again.
@anuragkhare3342
4 жыл бұрын
If we have multiple file but we dont have same sheet name in files. Column names are same in every file. Can we do it through SSIS..?
@kylekastilahn
3 жыл бұрын
sounds like you'd be using a for each loop container, variables and possibly script task. i think lesson 18 used some of those options, as does second part of this section.
@syamprasadp1994
2 жыл бұрын
bro could you please share the excel sheets also for the practice
@AmarKumar-kw9qy
9 жыл бұрын
hello aamir sorry to ask u so many question at a time iam trying to learn as many as packages u have showed nad my problem is in Load Multiple Sheets from Multiple Excel Files to Different SQL Server Tables in SSIS Package u said to have same excle connection manager in the second data flow and select the sheet but if select the same excel connection manage iam unable to get the second excel instead iam getting the details (columns) of first connection manger is their any thing iam missing
@TechBrothersIT
9 жыл бұрын
Amar Kumar In your second data flow task, you will bring the Excel source. Open Excel Source. In connection Manager, choose the existing Excel Connection Manager. Then go to Sheets drop down. Select the second sheet name. Go to Mapping and take a look if you are getting all columns correct. Then you will bring OLE DB Destination and map the input columns to your destination table.
@AmarKumar-kw9qy
9 жыл бұрын
TechBrothersIT thanks aamir for ur kind response but aamir in the second dataflow task in the excel source if i select the same connection manager iam unable to view the second excel file instead iam getting the sheet names of first excel sheet so can u please say what can be the issue i have checked the all sheets after selecting the same excel connection manager but iam unable to get the second excel file sheets in that connection manager
@devexpost8508
7 жыл бұрын
*Description of what is occurring:* 1. The input-file folder name is user supplied by the Package level variable "InputFolderPath" to the Foreach Loop Container. 2. Within the Foreach Loop Container, the looping occurs based on iteration over an enumerator type, and the enumerator type chosen here is “Foreach _File_ Enumerator” in order to cause iteration over files in the Directory based on the Enumerator Configuration which was set to include Files: “*.xls”. 3. With each iteration of the Foreach Loop, the Foreach Loop Container retrieves the current (next) “Fully qualified” .xlsx file name from the Directory folder as a “Collection Value”, and user-defined Container-level variable “FullPath” is mapped to the Index=0 string of this Collection Value (which now contains the fully-qualified path and file name of the current Excel file). 4. The Container then passes control to the Data Flow task which calls the Connection Manager and supplies the Container-level user variable “FullPath” whose value is dynamically assigned to the Connection Manager’s “ExcelFilePath” parameter. 5. The Connection Manager then opens the current Excel file identified by the “ExcelFilePath” parameter and permits the Data Flow task to process it. When the Data Flow task is complete, control passes back to the Foreach Loop Container which then looks for a next Excel file in the Directory. If another file is found, the Container continues again with step #3 above. 6. If no more files are found in the Directory then the Foreach Loop terminates. .
@BoxerDogs
5 жыл бұрын
I have never used SSIS. Why are you in Visual Studio to create an SSIS package, instead of being in SSIS itself?
@TechBrothersIT
5 жыл бұрын
Hi, Vistual Studio is the tool you need to use to develop SSIS Packages. The compact version is called BIDS that has templates for SSIs,SSRS , SSAS etc.
@sharabarathan3433
7 жыл бұрын
My pkg is executing but I am not getting any data in my destination file . Getting this in the output list - Any help will appreicate. I recheked few time the file path and file in the folder and its all correct. What could be causing this. Driving me crazy - "For Each File enumerator did not find any files that matched the file pattern, or the specified directory was empty. SSIS package "C:\Users\thunoli\Documents\Visual Studio 2010\Projects\fullnameDerivedTest\multipleSheet source.dtsx" finished: Success."
@currenttoff1753
2 жыл бұрын
my loop is not stopping after entering the records from both the files and both the sheets
@ravindergoud7584
5 жыл бұрын
I am having files 5 number of files with multiple sheets with same metadata kindly advise how to load in Sql by SSIS
@TechBrothersIT
5 жыл бұрын
Hi, can you please check the scenario on website. I have posted this type of many scenarios.
@saddalaharinadh6368
2 жыл бұрын
Hi sir
@dragontrans
8 жыл бұрын
How to Load Multiple Sheets (with diferent columns) from Multiple Excel Files to Different SQL Server Tables + skip first xy rows
@TechBrothersIT
8 жыл бұрын
Hi, please visit the Excel Source and Destinations (Script Task- Dynamic) Heading on below link www.techbrothersit.com/2014/12/ssis-videos.html You might have to combine two posts/videos together to make things happen for your problem.
Пікірлер: 71