This chapter shows that besides using .NET within an SSIS package, you can also use .NET to create an SSIS package. Although that sounds like a lot of work, especially when you can easily do that in SSDT by using drag-and-drop, there are benefits.
Creating a couple of staging packages is not the most challenging work, but what about creating dozens of them? That could be really tiresome and error-prone if you don’t pay attention. Beyond not having to do the boring part of ETL, mass-producing packages has the following benefits: