lassoman

That's exactly what I though! Holly cow......maybe I should take my name off the organ donors list. Have heard of people 'coming back to life' after being incorrectly pronounced dead (even young ones) and from memory there has been a few cases where people were buried alive, waking up in the coffin only to find out that they will come out of it alive again. If that is the common practice I think that medical practitioners should start questioning their suitability for this job!

If you just need to move data from A 2 B than no. If your transformations are complex and will grow overtime than yes, the time and learning curve are justified IMO.

I don't think so. I used it since it was DTS, not SSIS and whilst Informatica is better at all things ETL, SSIS is great for what it can do out of the box. Besides, if it can't, you can always do it via custom C#or VB extension.

Just finished a multi-terabyte data warehouse project where all data is loaded using SSIS and ControlM and it works great! The dev process was also easy and trouble-free.

Pentaho if you have no or little money or SSIS (comes with SQL Server licence)

Fully agree! This article is based on merits that I would hardly consider if making a choice between any relational engine. It is even more disturbing that the author claims to be a data analyst. CSV support.......R U serious? Who in the right mind would spend hundreds of thousands of $$$ for SQL Server Enterprise Edition licences and regret it because PostreSQL can do it better for free? I'm using both and they're both great but not for or in spite of the reasons outlined here. Author needs to educate herself/himself better before publishing this nonsense.