Cannot connect to WMI provider. You do not have permission or the server is unreachable. »

Here’s a great overview of the new features of the upcoming version of SQL Server Integration Services, code-named ‘Denali’. Things are just getting better and better. Most notably in this presentation: DTS packages of pre-2000 SQL Server are not supported anymore. ActiveX scripting is dropped as well Productivity for developers (undo/redo e.g.) Improved logging and eployment You can also pick up the slides of the presentation here.

My experience with the various SQL Server services. »