O'Reilly logo

Extending SSIS with .NET Scripting: A Toolkit for SQL Server Integration Services by Régis Baccaro, Joost van Rossum

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

CHAPTER 18

image

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. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required