vidalst (10/22/2013)
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.
Sorry, but Pentaho is a MUCH more polished tool. It supports both variables and parameters and both reports/ dashboards can be defined with the BI server. Versioning is a matter of using the right open source version control tool (like Git) Reusing a pilot against SQL server took a few minutes to get a workable version against Oracle. With SSIS this was really a painful exercise. You need the enterprise version to get ANY performance against any other DB than Sql Server