WellsCarrie
Well-known member
I have an SSIS package the runs consitantly with a successful exit code, when run manually. However when I try to run the package from my VB.net applicaiton it returns "DTSExecResult.Failure". I get no errors in my package and no errors in Catch statement of my vb code. Can anyone tell me where to look for the issue?
Here's my vb code:
Any ideas would be helpful right now.
Here's my vb code:
VB.NET:
Private Function LoadData() As Boolean
Dim bol As Boolean
Dim app As New Application
Dim myPackage As New Package
Dim result As New DTSExecResult
Try
myPackage = app.LoadPackage("c:\\GatekeeperWorkFiles\pckGateKeeperLoad.dtsx", Nothing)
result = myPackage.Execute()
If result = DTSExecResult.Failure Then
bol = False
Else
bol = True
End If
sb.Remove(0, sb.Length)
sb.Append("SSIS package reported ")
sb.Append(result)
sb.Append(" as its result.")
LogMsg(sb.ToString(), 300)
Catch ex As Exception
bol = False
sb.Remove(0, sb.Length)
sb.Append("ERROR - ")
sb.Append(ex.Source)
sb.Append(" - ")
sb.Append(ex.Message)
LogMsg(sb.ToString(), 300)
Finally
result = Nothing
myPackage.Dispose()
app = Nothing
End Try
Return bol
End Function
Any ideas would be helpful right now.