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