executing a SSIS package

WellsCarrie

Well-known member
Joined
Jul 12, 2005
Messages
95
Location
Arkansas
Programming Experience
5-10
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:
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.
 
Back
Top