DTC on my machine was broken (think after installing SQL6.5 a while back) I fixed it as per MS document (http://support.microsoft.com/?kbid=891801&SD=tech) Since then, any packages I try run in VS hang for a while (around 30 seconds) and raise an error Failed to start Project
All services are backk to the way they were before fixing DTC. Stopping DTC service has no affect. Even the simpliest package with only a script and msgbox hellow world will not run.
Full error is: Failed to start Project Additional Information: Cannot process request because the process (1492) has existed
The process ID changes every time I try run it. (Assume it's a PID)
VS info: VS: 2.0.50727 Microsoft SQL Server Integration Services Designer Version 9.00.2040.00
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.