How to stop a Hanged running Package (Don't want to restart System)
Hi, I ran one package and it got hanged and SQL Server BIDS is showing message Microsoft Visual studio is busy and I was not able to do anything in BIDS because it got hanged. I went to Task Manager and End the process. Again I opened same package and it is getting hanged and I am not able to do anything. I checked in SQL server Management Studio, Target table is locked because package is having TransactionOption=Required and even after closing package it is running and locking Target Table. I know one solution of this “Restart your System” Or "Restart Server" but I don’t want to do this. Please can you tell me how can I stop that running package? NOTE: Whenever I try to open that package it is hanging (Validating Sequence Container, where TransactionOption=Required) and then not able to do anything in BIDS. So please tell me from where I can stop that running package? Thanks Shiven:)
March 31st, 2011 6:14am

Does killing the DtsDebugHost proces help?Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com
Free Windows Admin Tool Kit Click here and download it now
March 31st, 2011 6:26am

Thanks SSISJoost, Here is the solution: Go to Task Manager->Processes->Select DtsDebugHost.exe and click on End Process. Next Time when you will open package, it will not in hanged status.Thanks Shiven:)
March 31st, 2011 6:44am

Hi, Again I am facing Problem "Microsoft Visual studio is busy", when I open one package which is having TransactionOption=Required and taking infinite Time for validation and not allowing to do any thing BIDS. DtsDebugHost.exe is not running in Task Manager. How can I open this package for working on it. Thanks Shiven:)
Free Windows Admin Tool Kit Click here and download it now
April 5th, 2011 2:41am

Have you tried working offline so you can open/change your package without waiting for validation? Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com
April 5th, 2011 2:48am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics