I would like to know how I can monitor the execution of an SSIS package
that has been kicked off from a VB.Net component using the DTExec
command. I did this in VB 6.0 using the reference to Microsoft DTS
package object library and with the following code:
For Each oStep In oPackage.Steps
If oStep.ExecutionStatus = DTSStepExecStat_Completed Then
If oStep.ExecutionResult = TSStepExecResult_Failure Then
Call oStep.GetExecutionErrorInfo(lErrNum, sSource,
sDescription)
sMessage = sMessage & " " & "Step " & oStep.Name & " failed, error:
" & lErrNum & " " & sDescription & "."
End If
End If
Next
Thanks!
Sara

*** Sent via Developersdex http://www.developersdex.com ***

You want to monitor from within the app?

The object library and code you are using is for DTS but you are firing off
an SSIS package. This won't work.

Have a look here in BOL

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/dtsref9mref/html/M_Microsoft_SqlServer_Dts_Runtime_Application_Load FromSqlServer_3_66b68031.htm

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/dtsref9mref/html/M_Microsoft_SqlServer_Dts_Runtime_Wrapper_IDTSPack age90_Execute_1_0f2cf976.htm

--


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com


"Sara" <nospam (AT) devdex (DOT) com> wrote