Apparently DTS already keeps count of the rows it processes. I'll
just bet there's some way of putting in a post-source or pump-complete
handler that accesses that number, rather than keep my own count by
incrementing a global on each row.

I've only just been introduced to the mystery of the multiphase data
pump, so, does anybody have the magic word on how to use it to capture
the row count in one swell foop?

Thanks.

Josh

This is a very quick example for you


Function Main()

dim tsk

set tsk =
DTSGlobalVariables.Parent.Tasks("DTSTask_DTSDataPu mpTask_1").CustomTask

DTSGlobalVariables("RowsSuccess").Value = tsk.RowsComplete
DTSGlobalVariables("RowsBad").Value = tsk.RowsInError


MsgBox "Success = " & DTSGlobalVariables("RowsSuccess").Value & " and Bad =
" & DTSGlobalVariables("RowsBad").Value

Main = DTSTaskExecResult_Success
End Function

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"JRStern" <jxstern (AT) bogus (DOT) com> wrote

On Sat, 29 Jan 2005 06:56:26 -0000, "Allan Mitchell"
<allan (AT) no-spam (DOT) sqldts.com> wrote:
Looks great, thanks!

Josh