Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Failed to Start Project in SSIS after fixing DTC

Unanswered Failed to Start Project in SSIS after fixing DTC

  • Wednesday, April 12, 2006 8:25 AM
     
     
    Sign In to Vote
    0
    Hi All,

    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


    SQL 2005 SP1 was installed a couple days ago.


    Any one have this kind of error?
    Cheers,