robert.goudie-497430 (12/18/2009)
BTW we still use DTS - despite having several books at work on SSIS that our key people have read at one point or another.
Thus far we have found DTS easier and more intuitive: SSIS takes a heap longer to achieve what comes intuitively in DTS, and this despite having no DTS documentation at all.
I use SSIS rather infrequently and when I come back to it I inevitably reinvent the whole Anglo-Saxon dictionary of biological insults and blasphemy. Once I get back into the swing of it I start to like it but should I have to get into the swing of it? Shouldn't it be more intuitive.
The particular gripe is the bit about changing package properties requiring them to be entered into a list in one of the components. There is a scripting equivalent that is supposed to negate this need but I've never got it to work.
I think SSIS will eventually evolve into something whose power is matched by an intuitive way of doing things but I personally I feel it has a way to go yet.
SQL2008 has one or two features that are in the "close but no cigar" camp. CDC looks good, until you have to factor in agile development changing the schema every 5 minutes.
Policy based management looks good but I want to audit naming conventions on fields.
Switch partitioning really rocks though!