I attended the Melbourne meeting of the Australian SQL Server user group last night, which this month presented on DTS in SQL Server 2005.
Firstly the presenter David Lean (Principal Technology Specialist - Database & Line of Business Applications, Microsoft Australia) was excellent. Not only did he cover the technical features with great depth but he also provided many interesting and sometimes offtrack valuable personal insights. In my opinion this is what really makes a good presentation, as when it comes down to it most people are capable of following a presentation script reasonably well, but it is the personal experiences that usually provide the most valuable knowledge.
Secondly SQL 2005 is certainly looking like an impressive beast. I had previously seen a presentation on using .Net for functions withing SQL 2005 which will hopefully mean that I will never have to write another cursor again, which looked good but the new features of DTS were far more impressive.
particularity impressive was the designer interface which is now grouped into logical screens for workflow, dataflow , event handlers etc. Also the addition of looping capability, file reading and writing and fuzzy lookup also look really good. As well as the ability to show the data's progress as well as view a sample it at each step in the package.
The only downside is that we will probably have to wait until mid way through next year at the earliest before we can start using it.
View Event - Australian SQL Server User Group