Dane Horne (one of our local Perl Mongers) did a talk the other month about an Open Source ETL package he's developing called ETLp. Like metaperlCorion, Dan had found that the visual ETL tools really did not scale and became very frustating for non-trivial problems. Anyway, check out his project.

Edit: fixed ref to earlier commenter