Yes it's horrible to administer. We have high profile DBAs. One of them was on the SQL Server team a few years back. A huge amount of work is generated for them that is unnecessary on other platforms.
SSIS is a pile of shit. It's impossible to test properly, suffers horrific deployment problems, is very unreliable and the only way to get transactional guarantees is using DTC which literally destroys your performance.
A better solution is something like spring batch / spring integration back off a queue solution.
SSIS is a pile of shit. It's impossible to test properly, suffers horrific deployment problems, is very unreliable and the only way to get transactional guarantees is using DTC which literally destroys your performance.
A better solution is something like spring batch / spring integration back off a queue solution.
Agree that NIH/DIY is bad here.