Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  SSIS and Import/Export (2005)  .dtsx Package hangs on "Stop Debugging"

Author  Topic  nkk9960 Starting Member 1 Post Posted - 2010-07-08 : 17:21:37 Hello! I've been working on several .dtsx packages to convert a database from Oracle to SQL Server, using the Business Intelligence environment from Visual Studio 2008. Recently, I've started having an anoying problem: I run a package (using the "Start Debugging" green arrow) The package executes fine (I get the "Success" message) I stop the package (using the "Stop Debugging" blue box) The environment just hangs! This seems to happen randomly, and more and more often. I can see in my database that the package executed fine. The only way I've found to get out of this is to go to the Task Manager, shut down the environment, then restart it. Does anyone know what is causing this, and how to fix it? Thanks!