Another vote for Pentaho... Whilst it isn't as polished as SSIS and lacks the nice SQL Server integration features (i.e. versioning, environment variables, reporting), it shines for non-SQL backends (DB2, Progress) where SSIS struggles with native datatypes.