To Adolf... You wrote, "It's the windows 98 of the database world." B.S.!! It's free. Go buy Informatica or something. Jamie's comment regarding the budget is true. These guys built a product right out of the gate to fulfill an ETL space in their tool belt. They did it, and packaged it with SQL Server. You buy SQL Server you get SSIS. Pretty neat, huh! So until you have to pay for it, it's a touch absurd to say this product sucks. It's pretty dang powerful (you mean I can program in .Net INSIDE my SSIS package?!?!?) for a first generation product.
This annoys me because it assumes that "free with SQL Server" is a license to suck. SSIS isn't free, by the way, it is part of the SQL package, which cost quite a bit. Even beyond that, it isn't free in the most important term I can think of, it is wasting my time.
Oh, and I am decidedly unimpressed with being able to run .Net in my SSIS package, that is an ability that I can add to an existing application in an hour, so that is not any reason to get excited.