For developers, is it worth it to learn/use SSIS?
.net, etl, linq, package, ssis
Solution
I don't know SSIS, besides reading up some of the basics. Also like you I'm very comfortable with LINQ, and could quickly write code to push around and transform data.
But what if the table has 4 gigs of data? Do you think your LINQ code is going to handle that gracefully? It could be handled, but not easily, especially if there are a lot of tables cross-referencing each other. A naive LINQ implementation would try to load everything into memory and crash.
Another justification is because your coworkers are strong with SSIS. Any solution you give the company built on SSIS will be more valuable to the company than LINQ, since other people can pick it up and fix or extend it.
Problem
I'm starting to get involved in quite a bit of ETL work a my current job, and everyone seems to be pretty partial to SSIS. I'm struggling trying to do the most trivial transformations through BI studio that would usually equate to a couple foreach loops with a pinch of LINQ. Im not sure of the use cases or users this tool would be useful for, and will probably convince management that I can do without. What's the best way to make my case, or if there are any recommendations for better tooling, that would be appreciated as well.