well explained and you made this to understand in easy way sir.thank you sir......plz make a such videos to understand the concept with more examples.....
Here is a task for you to do Soni! Create a flat file .txt format. You can utilize Excel to create the table first and then save it as .CSV and then open the .CSV, copy and paste it to text editor and save it as .TXT file. The table will have 10 rows of data across its three columns. Columns are student_id, course, grade. So records in each row would look like bush_001, calculus, A, soni_002, linear_algebra, B and so on... Once you created that .txt file, name it student_records. Then I want you to create a database lets call it test and then right into test database I want you to create a table with correct data type aligning with your flat file student_records. Then I want you to find an ETL solution by following this lecture. If you can do it in one chance, I would say you have brain, if not, then it may be you really need to work hard to clear your conceptions....
I found your lecture useful although I must admit it was hard for me to understand and not because your lack of understanding of the subject matter but due to the way you utilize English in an Indian manner. It's pretty straightforward to find ETL solution when it comes to Excel file and flat file (.csv, .txt). I wonder how challenging it can get when it comes to conduct the ETL to extract data from let's say PostgreSQL or MySQL and load it into SQL Server 2019? Keep up the good work!
![ETL Process using SSIS [Real Time Practical Example] Step By Step](http://i.ytimg.com/vi/ji2rigGiWis/mqdefault.jpg)
Simple and Excellent Class Very clear and makes it easy I saw so many Class on SSIS, but this class is so good thank you Sir ❤️🎈
well explained and you made this to understand in easy way sir.thank you sir......plz make a such videos to understand the concept with more examples.....
Awsome simplest one I’ve seen thank you
Simple and Excellent tutorial for beginner, thanks a lot
Glad it was helpful!
you explained concept in quite easy way, keep making video like this. Thanks!!
Thanks, will do!
Its really nice video...simple and nice explanation
Thanks for video, it is very helpful for beginners.
very clear :)
This is the easiest tutorial I've come across, can you share the link to your subsequent video pleaseeeeeeeeee?
very simple and Easy understanding. Greta Job!
Thank you!
Awesome..... much useful. Thanks !!!
That was really good
Thank you
Thank you for this amazing video
My pleasure!
Very Easy to learn within few minutes. Great job. Is it possible to share link for next video to learn advance concepts
Awesome
very nice
where can we find your repository for the file samples for practice. thank you
Please clear the drawbacks and need of ssis
when will you add in excel in video total column dear ? its automatic created or manual ? thanks for this video
Thank u
I thought u must be having a lot of Content on ssis, pls make more tutorial on ssis & ssas
Sure, I will upload them here
Can you please provide some basics questions/ tasks that can be done with ssis
Here is a task for you to do Soni! Create a flat file .txt format. You can utilize Excel to create the table first and then save it as .CSV and then open the .CSV, copy and paste it to text editor and save it as .TXT file. The table will have 10 rows of data across its three columns. Columns are student_id, course, grade. So records in each row would look like bush_001, calculus, A, soni_002, linear_algebra, B and so on... Once you created that .txt file, name it student_records. Then I want you to create a database lets call it test and then right into test database I want you to create a table with correct data type aligning with your flat file student_records. Then I want you to find an ETL solution by following this lecture. If you can do it in one chance, I would say you have brain, if not, then it may be you really need to work hard to clear your conceptions....
Thanks Bushmaster, I missed to reply on this threa earlier but totally liked the task :)
I found your lecture useful although I must admit it was hard for me to understand and not because your lack of understanding of the subject matter but due to the way you utilize English in an Indian manner. It's pretty straightforward to find ETL solution when it comes to Excel file and flat file (.csv, .txt). I wonder how challenging it can get when it comes to conduct the ETL to extract data from let's say PostgreSQL or MySQL and load it into SQL Server 2019? Keep up the good work!
Thank you !!