Background: I was recently hired to develop C# ETL code (or for transferring data) in Visual Studio. However, my only experience with programming is one introductory programming class in Java that I took in college a couple of years ago, I’m a lot more experienced and proficient with SQL. I made all of that clear in the interview process.
I understand most of the syntax for C# on a basic level, and I understand most of the basic programming concepts such as OOP, inheritance, polymorphism, etc, but I could also use more training on them. I’ve also been getting decent with using Visual Studio. I know how to debug, look at the code maps, find stuff on items, etc.
Since I started working my boss has been having me study the code. I feel like I’m making progress, but not at the rate that I would like. I don’t understand what a lot of the lines do, and I’ve been having trouble understanding how the solution works as a whole. I’ve told him all of this and have been transparent with where I’m at, and he’s perfectly fine with all of it. I still feel like there has to be a better way to learn all of this though.
Does anybody know of any classes that would be good for teaching me how to write ETL code in C#?
Ssis ? What Etl frame work. Conceptually etl is the same in any language. It’s just syntax. You haven’t really asked a question unless you don’t know what ETL is. Writing etl isn’t a specific c# thing.
I hate SSIS, but it’s probably a better solution for your needs than C#. Heck, most of my SSIS code is just calling SQL scripts to do the real transformation work.
https://www.brentozar.com/archive/2018/07/video-ssis-design-patterns-extract-load-and-transform/
https://andyleonard.blog/