Hi,

I have a task delivering every 15 minutes a number of lines from a database.

Is it possible to store the number of selected rows in a global variable for
further use in the package?

I don´t like to send two statements, one for the count and the next one for
the resultset because of performance problems.

Thanks for answers.

Best regards,
Guntram

Have a look at these properties on the DataPump task

RowsComplete
RowsInError



"Guntram Ulrich" <ulrich (AT) vivai (DOT) com> wrote

In message <uAp$F2lVFHA.2664 (AT) TK2MSFTNGP15 (DOT) phx.gbl>, Allan Mitchell
<allan (AT) no-spam (DOT) sqldts.com> writes
.... and you can use an ActiveX Script Task to read them and set the
global variable as required.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

I am only working on dts tasks in the gui interface of the enterprise
manager.

Can you tell me where I can find these two properties?

Thanks in advance.

Best regards,
Guntram

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> schrieb im Newsbeitrag
news:uAp$F2lVFHA.2664 (AT) TK2MSFTNGP15 (DOT) phx.gbl...

Create a Audit table and
keep track of your info using the 'Execute SQL task'

Panch

This has helped me.

Thank you,
Guntram

These two properties are not "grabbable" from the GUI itself (You will
love 2005 though).

You will either need to compare row counts before and after in the table
OR you will have to write a small piece of Active X script to get the
values.

Allan

"Guntram Ulrich" <ulrich (AT) vivai (DOT) com> wrote