SSIS Custom Components

Designing custom components for SSIS is a complex task.

Much of the available documentation is not very intuitive, and although technically correct, can be simply unfathomable.

There is a step learning curve , with many trips and false starts upon the way. Once understood though, the benefits in code reuse and overall performance can be well worth the effort.

Once you have understood the data flow functionality, then the hurdle of creating a UI will then have to be crossed.

Starting with a blank project , the end to end process will be demonstrated to allow you to get all the benefits.

"Just make it go faster”

That’s a standard command that gets filtered down through the management on an all too frequent basis.

How can that best be achieved? Sure you could throw hardware at the problem, but how do you know that that will solve the problem and at what financial cost. Alternatively you could partition tables, use created clustered views or any manor of tweaks.

But are you just papering over the cracks? Without addressing the underlying problems then you are not going to achieve real performance, scalability and create a system that performs in a predictable fashion.

By re-engineering some cursor ridden code, we'll see how that can be achieved

Craig Farrell (4/18/2011)

---

Not sure, honestly, but how many people do you expect to attend PASS that don't know how to remove cursors for speed?