• The BIML engine does some of the same kind of "invisible hand" stuff that the SSIS designer does for you when you wire up objects in a data flow.

    If you've ever tried to programmatically manipulate an SSIS package (either directly or via EzAPI), it's easier to envision what BIML is effecting when you "compile" your BIML file to SSIS package from this. You'll also understand how easy it is to blow things up when you don't hook things up right...

    BIML is a nice abstraction over the process, way more so than EzAPI, which itself is way more so than directly using the SSIS libraries in .Net world.

    I'd rather type a bunch of stuff than the click-fest that is working with the SSIS designer.