Heh... yeah... I wish MS would figure out that T-SQL is a great place to do ETL from and that you don't really need SSIS... in fact, if you hold your mouth just right, it seems like you can do a lot more in T-SQL than SSIS unless you count all the Active-X scripts that folks write. I'm working on replacing a DTS step that splits and "impossible-to-import" file that they used a Perl script on... the Perl script takes 40 minutes just to get the data ready for import. The T-SQL I've written to do the same job weighs in at about 27 seconds.

It would be nice if they'd stop removing features... undocumented features like xp_GetFileDetails and xp_DirTree (available in 2k, 2k5, and 2k8) should be documented and kept because they're bloody useful.