Хоть я и идиосинкратичен к опен софту в разделе "бизнес", но не могу молчать.
Вчера проект Pentaho купил Kettle, оттуда я о них и узнал.

Фришный опенсорсный ETL, визуальный, на джаве. Доступен для скачивания здесь

Ско4ал, поставил.

На первом же тестовом трансформе MSSQL->SQL случилась ж.

2006/04/06 13:28:33 - Table output.0 - Connected to database [RC_DS_Out_20060319] (commit=0)
2006/04/06 13:28:33 - ft_POS_Sales_Agg_TX_2005.0 - Starting to run...
2006/04/06 13:28:33 - Table output.0 - Starting to run...
2006/04/06 13:28:33 - ft_POS_Sales_Agg_TX_2005.0 - Finished reading query, closing connection.
2006/04/06 13:28:33 - Table output.0 - ERROR : Because of an error, this step can't continue:
2006/04/06 13:28:33 - Table output.0 - ERROR : Error performing rollback on connection
2006/04/06 13:28:33 - Table output.0 - ERROR : rollback() should not be called while in auto-commit mode.
2006/04/06 13:28:33 - Table output.0 - Finished processing (I=0, O=0, R=1, W=0, U=0, E=1
2006/04/06 13:28:33 - ft_POS_Sales_Agg_TX_2005.0 - ERROR : Unexpected error closing query : be.ibridge.kettle.core.exception.KettleDatabaseException:
2006/04/06 13:28:33 - ft_POS_Sales_Agg_TX_2005.0 - ERROR : Couldn't close query: resultset or prepared statements
2006/04/06 13:28:33 - ft_POS_Sales_Agg_TX_2005.0 - ERROR : Cancel has been invoked on this Statement.
2006/04/06 13:28:33 - ft_POS_Sales_Agg_TX_2005.0 - Finished processing (I=221, O=0, R=0, W=219, U=0, E=1
2006/04/06 13:28:47 - Spoon - Transformation opened.
2006/04/06 13:28:47 - Spoon - Excecuting transformation [testTrans]...
2006/04/06 13:28:47 - testTrans - Dispatching started for transformation [testTrans]
2006/04/06 13:28:47 - testTrans - Nr of arguments detected: 10
2006/04/06 13:28:47 - Table output.0 - Connected to database [RC_DS_Out_20060319] (commit=0)
2006/04/06 13:28:47 - Spoon - Started.
2006/04/06 13:28:47 - Table output.0 - Starting to run...
2006/04/06 13:28:47 - ft_POS_Sales_Agg_TX_2005.0 - Starting to run...
2006/04/06 13:28:47 - Table output.0 - ERROR : Because of an error, this step can't continue:
2006/04/06 13:28:47 - Table output.0 - ERROR : Error performing rollback on connection
2006/04/06 13:28:47 - Table output.0 - ERROR : rollback() should not be called while in auto-commit mode.
2006/04/06 13:28:47 - Table output.0 - Finished processing (I=0, O=0, R=1, W=0, U=0, E=1
2006/04/06 13:28:47 - testTrans - ERROR : Errors detected!
2006/04/06 13:28:47 - testTrans - Looking at step: ft_POS_Sales_Agg_TX_2005
2006/04/06 13:28:47 - ft_POS_Sales_Agg_TX_2005.0 - Finished reading query, closing connection.
2006/04/06 13:32:32 - ft_POS_Sales_Agg_TX_2005.0 - Finished processing (I=329, O=0, R=0, W=327, U=0, E=0
2006/04/06 13:32:32 - testTrans - Looking at step: Table output
2006/04/06 13:32:32 - Spoon - The transformation has finished!!


Кто-нибудь прошел дальше этого?

Получилось забирать данные из SAP в MSSQL - в комплекте Kettle идет SAP-коннектор (не бесплатный).
Пока пощупанная функциональность на уровне MS DTS 2000.