There is an unsaved comment in progress. You will lose your changes if you continue. Are you sure you want to reopen the work item?
Hanging on Execute SQL Task that returns a single row result but fails
If an Execute SQL task fails when returning a single row result (no rows returned to be loaded into the variables), it appears that DTLoggedExec never finishes, and just hangs. I ran a Package.Execute without the custom event handler and the error was
logged and the execute method finished. I wonder if it's something to do with the custom event handler?