CHAPTER 18
Package Creation
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:
- Speed: Even the most experienced SSIS specialist can’t create 50 or more packages in a day. ...
Get Extending SSIS with .NET Scripting: A Toolkit for SQL Server Integration Services now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
