DTSGlobalVariables("GoodRows").Value = oDataPump.RowsComplete -
oDataPump.RowsInError
DTSGlobalVariables("BadRows").Value = oDataPump.RowsInError
DTSGlobalVariables("TotalRows").Value = oDataPump.RowsComplete
RowsComplete is all rows transferred, so this is also the total. RowsInError
is
the failed rows, so the good rows is the total less the errors.
--
Darren Green
http://www.sqldts.com
"Serghios (AT) community (DOT) nospam" <Serghios (AT) community (DOT) nospam
@discussions.microsoft.com> wrote
Quote:
Hi,
I am transferring data between two SQL tables and I want to store the
number of rows successfully and those not transfered into 2 global
|
variables. How can i do this?
Re: Roes Failed and Succeeded -
08-04-2004
, 10:30 AM
Linear Mode
