sql server dts: How can I programmatically get a count of exceptions after the data
pump has finished?

Thanks.

On Wed, 31 May 2006 11:27:03 -0700, jxstern <jxstern@wherever.com>
[quoted text, click to view]



'**********************************************************************
' Visual Basic ActiveX Script
'**********************************************************************

Function Main()
Dim sMsg
Dim oTask
Dim oDataPump

' Set oTask =
DTSGlobalVariables.Parent.Tasks("DTSTask_DataPump_1")
'---- see oStep.TaskName in .vbs or the transform name in the GUI
designer

Set oDataPump = oTask.CustomTask

sMsg = "Rows in error cnt=" + CStr(oDataPump.RowsInError)
MsgBox sMsg

Main = DTSTaskExecResult_Success
End Function