If you attempt to debug a package and the package will not run in the designer. Also, if you attempt to execute the package by selecting Debug | Start Without Debugging and it correctly executes, you may be seeing an issue with setup that we've seen on some machines.
If you're experiencing this problem, look the registry value under:
HKEY_CLASSES_ROOT\TypeLib\{3ED4D7CC-1ECC-4D11-9AC7-FFA71CE45705}\1.0\0\win32
It should look something like this:
C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\DtsDebugHost.exe
If it has quotes around it, remove the quotes. That should fix the problem.
Thanks to Michael Entin on the SSIS dev team for figuring this out for one of our customers. Hopefully you haven't seen this, but if you do, this should fix the problem.
Thanks,
Universe.Earth.Software.Microsoft.SQLServer.SSIS.KirkHaselden