SQL Server 2005: DTS

Lets start with the best quote: “We’re not even sure it’s still going to be called DTS.” That pretty much represents how much things have changed. There’s a new development environment (as yet unnamed) with different panes for work flow and data flow (how novel). There is now flow control (for, foreach, etc loops), security on packages is role based and built in error flow on most transforms: if it succeeds, it goes out the green arrow, if failed the red one. There’s an advanced session tommorrow, but I think I’m going to another session at that time. Next up: snacks and Planning your Office 2003 Deployment.