August 21, 2008 at 3:41 pm
Hello and TIA.
I'm a bit of a noob at using SSIS so please bear with me. I've created a number of packages to automate importing data from various sources. These are meant to be executed by a specific user. Originally, I was deploying the packages themselves but have been tasked to provide a GUI.
I can load packages and execute them fine. When there is an exception thrown, however, the vb.net (2005) application hangs. I have included an event handler which captures the OnError event and will message the user. What do I need to do in order to get the application to respond to user control again? (I end up using task manager to kill the process).
This is what I've tried so far:
Private Sub packageError(ByVal source As Microsoft.SqlServer.Dts.Runtime.DtsObject, _
ByVal errorCode As Integer, ByVal subComponent As String, ByVal description As String, _
ByVal helpFile As String, ByVal helpContext As Integer, _
ByVal idofInterfaceWithError As String) Handles eventListener.PackageError
ssisPackage.SuspendExecution()
ssisPackage.Dispose()
ssisPackage = Nothing
MsgBox("Error - Execution Cancelled (ERROR EVENT)")
End Sub
The Msgbox works but everything hangs after that. Am I missing something in the Package properties and/or setup? Is there a function or process that I'm not following correctly when trying to stop the package from executing?
Corey
August 21, 2008 at 3:43 pm
sry, i've found a more appropraite board to post this on.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply