What is SQL server not good at? SSIS (sorry, I know that is too general)

At least there should be documentation and warnings about the import issues that have persisted through various versions of the product and that MS is unlikely to fix or patch. I'm sure I'm not the only person who has spent hours or days researching an error message only to find out that the issue is a documented bug (but usually on a non-MS site like this one.)

So really my answer is MS is not good at honesty about known issues. There should be a central repository to list known issues and suggested work-arounds.