Sorry I haven't posted for a while (well, a few months) - I really must post more often (that is my resolution for July). I've just returned from a week's vacation in Spain. I stayed at a great villa in Jalon valley near Calpe. I have to blog about a restaurant called Oustau http://www.oustau.com/ingles/introduccion.html which is located in the fantastic town, Altea. The food is amazing, the location awesome and the weather is great all year! Anyway enough about that....
I must say I am impressed with SQL Server Integration Services. I have been using this product in a development environment for some time now, and although there are the some bugs in CTP builds, the product is very flexible and the IDE is stable. In comparison to DTS in SQL Server 2000, there are some major changes. I'd recommend reading the whitepaper available here http://www.microsoft.com/technet/prodtechnol/sql/2005/intro2is.mspx.
There are also some excellent blogs on this subject area (see below)